o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Mailmerge via ODBC -

How can I use an existing ADO recordset to create Word 2000 mailmerge documents?

 

Mailmerge via ODBC -
How can I use an existing ADO recordset to create Word 2000 mailmerge documents?


Mailmerge & VB -
Hi everybody, Now, I try to use Word Mailmerge via VB. Basically, I have to create a main document which I already accomplished and setup the datasource which I can't. I want to create a datasource in VB code and want to connect the database via an ODBC. Is there anyone know how to


MailMerge problem. Urgent! -
I am having a problem that is how to reserve the marco after mailmerge. The situation is I have a template which contains the macro for later use. But first the fields in this template needs to be merged from an Excel file. After I merged the file and send it to a new document using


Is it possible to send mailmerge word doc through IE -
Hi, I was wondering if it is possible to send a mailmerge word file through the internet. What I'm doing is as follows: - user logs into website - user enters information and submit - website takes information and mailmerge with existing template - sends user end result No


Merge two tables into one document -
I have two tables. One is a list of clients, and one is a list of data to be sent to all clients. I want to use Word to mailmerge the two together, except that there doesn't seem to be a way to do it! Any ideas on the best way to go about this? Should I create a multipage documen


MailMerge with C# example -
I have been hunting for a mailmerge example using C#, and all I can find ix examples using VB, has anyone seen a C# example?


[FAQ's: OD] How do I automate a Word MailMerge document -
Using the MailMerge object in the Word Object Model we can modify or execute a mailmerge on an existing mailmerge document. You may want to do this for reasons like filtering an output of records, sorting, changing a datasource (keeping the same fields), batch processing, etc. F


trying to create a macro that prints records -
ok, I'm trying to create a macro to print a record in work, then go to next record and then print it... and do this till the last record... what's wrong with my code? Help...... ************************************ Sub DoUntil() Check = True: ActiveDocument.MailMerge.DataSour


Try & figure this -
I have a general Word2000 document with fields linked to a dbf (dbase) file via MailMerge. I've now saved the Word document as an htm file. The fields still merge to the dbf file with IE's 'Edit with MS Word for Windows'. OK so far. But now I would like the htm page to MailMerge wi


Word MailMerge and VB 6 problem. -
Hello I am trying to send a mailmerge document to the printer after attaching the datasource file. See Code below. Code: Option Explicit Public WithEvents objWord As Word.Application Private Sub objWord_DocumentOpen(ByVal Doc As Word.Document) With Doc


VBA - mailmerge -
Hi, Im workin on a mailmerge-thing which merges with the Exchange addressbook and Im a little stuck... right now I have this code: Code: ActiveDocument.MailMerge.UseAddressBook Type:="olk" ActiveDocument.MailMerge.DataSource.QueryString = _ "


MS Word mailmerge automation -
Can anybody provide me with some sample code to automate the mailmerge function offered by MS Word from a Visual Basic program. Thanks for your help in advance.


mailmerge and recordset -
Can anyone tell me how to connect a loaded template doc with a mailmerge to a recordset ? im using the MSword9 object and vb6 sp4 Thanks anyway!!!


mailmerge with a recordset -
Hi, i've seen plenty of examples of doing a Word mailmerge with a temporary table, but is it possible to do it with an ADODB recordset? I've seen this question asked many times and not answered yet so if anybody has a solution i reckon you would be helping many people out! Ch


Outlook Mailmerge using VBA -
Hi I have tried posting this at various other outlook forums, but never had a single reply (maybe that says more about my Q than the people in the forums. I am trying to produce a macro with VBA in Outlook (to assign to an outlook toolbar) to do the following: - when outlook i


mailmerge from outlook to word -
can anyone tell me where i can get a simple code to setup an automated mailmerge from outlook contacts list ( select by category say ) to a single word form letter document. many thanks


open a mailmerge document -
Hello,I have searched the forum but couldn't find a solutuon to my specific problem.Actually I have created a mailmerge using microsoft word and as data source, i use a table from microsoft access.Every time i try to open the word document,I am given a msgbox telling me that opening th


Replace MailMerge -
ok this is my first stretch into vb.net so be gentle.... I want to open a word document that could look like something like this: Dear <CompanyName>, blah blah blah. I want to open this word document and replace the <CompanyName> tag with a mailmerge field. I can


Help ! How to use ODBC -
Hi, I need to develop an VB application that will retrieve data from a OS-2 server with DB2 as dbms. I know that ODBC will properly solve this problem, but i have no experince on ODBC. I have some qestion on ODBC, 1) Do i need to install ODBC driver into the OS-2 server ? 2) The VB


Is it possible to do this -
I am trying to make a system for my user in which it prints out labels. The problem is that now I have my query (it selects everything that my user will need on his label), I want to try the following: Make a macro (either from Access or Word) that allows him to select only certain


performance problem wihh odbc -
Im in trouble... We are using an ODBC connection to access IDMS. I have some serious performance problems. I have traced my asp.net app and got the following results: ODBC Open() 10 seconds ODBC Command() 5 seconds ODBC Close() 9 seconds These are .net odbc objects.


HELPPPP !!! About ODBC -
Dear All members and gurus, I'd like to ask about ODBC. Some of my old program still using ODBC as the connection. And, now, I've got to implement my program using 2 database with one DSN name at ODBC administrator. I know, maybe your suggestions will be ===> Change the conn


Help Required Urgently:In Continuation of thread Id=234230 -
Please refer to thread following thread http://www.vbforums.com/showthread.p...hreadid=234230 The problem is whenever I try to open the .doc file for mail merge, it's throwing an error that word was unable to open datasource. wrd.Visible = True wrd.Documents.Ad


Updating Through ODBC Help -
I am trying to update a record through ODBC on a AS400. I am using a Rumba optimized ODBC. I am able to get info from from the 400 just fine but I just can't get it to go the other way around and update. I am also trying to do it using a DataEnvironment right now. Does anyone have any


Word Mail Merge Issue -
I have a customer running Windows 98 and Word 2000. She's trying to run a VB application that attempts to do a mailmerge using the odbc driver for the AS/400. She keeps getting the following message: 5922 Word was unable to open the data source This application works just fine on o


ODBC with Oracle -
I could not get odbc connection with oracle. How can i get the connection using ODBC. When i created Datasource it is not showing Oracle Odbc Driver. It is giving sql server only. How to set ODBC with Oracle in Visual Basic 6. When i tried with coding it is not displaying oracle.


ODBC Access Question -
Hello All... Just a quick question to see if anyone has any ideas... I would like to be able to get information from an ODBC DSN (ie FileName and type). I know that I can get DSN information from the registry key \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI, but I was wondering how g


HOWTO: Remote ODBC Installs -
I just had to write this so thought i'd share: Sometimes you still have to use ODBC for legacy work, and all the users still have to have the ODBC installed locally, this can be done in many ways, a .reg file, an NT login script, or using VB.... Here's the project to remotely i


Query with ODBC connection -
Anyone know if it's possible to use Case statement and Substring for queries within a ODBC Connection? I had always use OleDB in the past and was able to do it, but for some odd reason when I use ODBC I can't seem to use that. Keeps giving me that an operator is missing even though i


***Resolved*** Mailmerge Problems Again -
I am trying to do a Word mailmerge from VB taking the Receipt data from an Access 97 Table. The code that I am trying to use opens my mailmerge document allowing me to view it in Word before printing it. Although I'm sure the code has errors in it and has lots of room for improvement,


Data Types, and File Saving -
I am doing a forced mailmerge from access to a word document, the table in my database I am using to do the merge from has a currency field in it. When I look in the field it has the $0,000,000.00 format, however when I do the mailmerge it formats it to the text of 0000000 how can I s


send query data to word doc via mailmerge V's Bookmarks -
i have searched but cannot find the best method of exactly how to achieve (Access not VB6) from a custom menu, send data from a query to a word document with either mailmerge or bookmarks. how can i do this and wich is the best method?


Crystal Reports 7.0 (ODBC connection) -
I am using Crystal Reports and VB with Access as my database. I create a ODBC connection in the control panel and point to the ODBC connection when I created the report in the design mode. everything works fine until I go to another machine with the same ODBC connection but everything


Need a challenge Try This !!! :p~ -
Dear All members and gurus, I'd like to ask about ODBC. Some of my old program still using ODBC as the connection. And, now, I've got to implement my program using 2 database with one DSN name at ODBC administrator. I know, maybe your suggestions will be ===> Change the


word mailmerge from excel data -
is it possible to set which sheet for word to use for mailmerge data, i have tried a few things, but it always uses sheet1, though sometimes it tries to work with a range from another sheet it still uses the data from sheet1


timeout in Word -
'lo ppl, I've got this serious problem right here. Im not sure this is the right place to ask but shoot here it goes... When I perform a mailmerge in Word with an ODBC link to an Oracle DB it takes too long. Word gives the message 'This task takes longer then expected, do you wan


Word Mailmerge problem (VBA): new name for merged document -
How to give a merged document another name than the one that's been attributed automatically by Word (Office 2000)? According to me the Mailmerge Object doesn't possess a name property for the merged document. Is it possible to use code to determine the name Word attributed to the me


MailMerge Loses Table Formatting -
I have a draft ammount in my Microsoft Access database tha automatically calculates currencies for me(the table is formatted for currencies). So the table stores numbers like this: 1921.2 as $1,921.20... But when i press the mailmerge key on my word document, the draft ammount look


ODBC API or ADO -
Hi, I am having one VB application that is using ODBC API to access a remote AS/400 database. It is hard to understand and difficult to maintain the application, since it is using API. I want to change it to ADO/OLE_DB. Which one will be faster, accessing data through ODBC (note no


Killing odbc -
Hi chaps!! Does anybody have some code to delete/kill a odbc data source, I have code to create one but it doesn't work if I have the odbc name setup lready. Another solution is the ability to change the underlining (Access97) database that the odbc is setup for.