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
.MailMerge.SuppressBlankLines = True
.MailMerge.MainDocumentType = wdFormLetters
.MailMerge.OpenDataSource App.Path & "\Letters\" & g_strUserName & "addlist.txt", ReadOnly:=True
.MailMerge.ViewMailMergeFieldCodes = False
End With
End Sub
And in module -
Set objPrintDoc.objWord = CreateObject("Word.Application")
With objPrintDoc.objWord
.Documents.Open strDocName, , True
.ActiveDocument.MailMerge.Destination = wdSendToPrinter
With .ActiveDocument.MailMerge.DataSource
.FirstRecord = wdDefaultFirstRecord
.LastRecord = wdDefaultLastRecord
End With
.ActiveDocument.MailMerge.Execute Pause:=False
End With
However, when I run this I keep on getting up a window asking what the delimiters are for field and line.
How can I get it so that the delimiter window does not appear?
Kev.
"She got her looks from her father. He's a plastic surgeon" - Groucho Marx
[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
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.
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
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
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
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
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
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 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
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
opening a Word mailmerge datasource -
I have created a mail merge datasource and open it via the Word object library in my app. If this is done with a PC with office 2000 on, then everthing is Ok. If it is a PC with office97 on, then I get an error opening data source. If I do this manually through word, I get the same pro
MailMerge Operations (Word.Application) -
Hi all!
I have a problem whith a MailMerge Operation in Word, I have made all the mail merge things from VB whith a txt file buld from VB but allways the word shows the window where I must select the field separator and the rec Separator.
How can I say this separators with parame
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
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 via ODBC -
How can I use an existing ADO recordset to create Word 2000 mailmerge documents?
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
Help with Word and Visual Basic -
Hi
I am new to Visual Basic and here is the project I must compelte. We currently have a Word document (that we mailmerge a flat file too). This document contains information for new hires. The users have asked that we add a couple of dropdown list boxes to the word document for t
MailMerge -
Hello,
I have a tiny problem.
I'm merging clientadresses from a database into word.
There's no problem until Word-document becomes Visible.
Only the last field is visible.
I need to insert a pagebreak or a space between the fields, but i don't know how to do that.
Can anyon
double quotes from Excel to Word mailmerge -
Hi,
I'm trying to do a mailmerge from Excel to Word 2000. The data includes some rather cryptic codes (after laying a truetype over the mergefield it will become a barcode) an can contain things like :
„„" (two lower double quotes followed by an upper double quote)
N
Microsoft Word Mail Merge -
Hi,
I am facing problem in MS Word Mail Merge.Below I create a document for mail merge and open the datasource. The problem is that every thing works fine except the database[gstrdatabase] entered, opens in MSAccess which is visible. I want to let the user see only the Word Document
***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,
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
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?
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
MailMerge Problems -
I have started having problems with MailMerge in my database - it has worked before but now I get this error:
Runtime error 5922
"Word was unable to open data source"
Here is my code:
Code:
Function MailMerge(strMMTemplate As String)
Dim objWord As Word.Appl
Automating Mail Merge with Word through VB 6 -
I have several Word 2000 Mail Merge Templates that I need to automate through my VB 6 application.#
The code I'm using at the moment is:
Dim wrdApp As Word.Application, wrdDoc As Word.Document, wrdMerge As Word.MailMerge
' create an instance of microsoft word.
access, word and headaches... -
OK, long and comlicated....
basically I'm trying to mailmerge a current record to word. I have a query that finds the current record from the key on the form but when i try to mailmerge it word starts a new session of access and then, no surprise, the query prompts for the form fie
access database, word mail merge... need i say more =) -
OK, long and comlicated....
basically I'm trying to mailmerge a current record to word. I have a query that finds the current record from the key on the form but when i try to mailmerge it word starts a new session of access and then, no surprise, the query prompts for the form fie
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
Access Mailmerge Automation -
Can anyone tell me how I can perform a mailmerge by opening up word from access and performing a mailmerge automatically
without opening access again as the datasource? I've copied the script below, if anyone has any suggestions please help!!!
Dim objWord As Word.document
Dim mywd
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
Using Word to Mailmerge in VB 6 -
Hi All,
I want to use VB6 to mailmerge, but can't find much help on the matter. There seems to be different ways to declare word and document objects. I have noticed that you can declare a word object as follows:-
Dim wrdApp As Word.Application, wrdDoc As Word.Document, wrdMerge
Excel Range to Word -
I want to be able to from a Word Macro copy a Range of Cell Values from Excel and paste them back into Word. I can't get word to read any values from excel.
I also want to paste from excel to a word datasource / mailmerge.
When using the saveas code in word, the user is not promp
not really VB but anyhow... -
Hi,
The reason I post here is coz I know ppl read the threads and have xperience with a lot of programming and may have an answer (btw MS KB sux)
If I use an outlook adressbook to create a Word document containing info from the adressbook (standard mailmerge) Word creates a virt
mailmege error 5852 with XP-works fine in 2000 -
I have a VB app that automates Word mailmerge It use an Access database for the input to the maimerge. The application works fine in 2000 and doesn't work in XP.
I get the error 5852 requested object is not available.
I get this message when it tries to execute the following line of
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
Pls Help : VB macro in word - hanging word -
Hi,
I am not basically a VB developer and trying out my hand due to one requirement that actually invokes the winword from my process in macro mode. I have written a macro and I expect a result as to give me the two documents:
1. word document - gebog578_1009_GEMBout.doc
2. prn fi
[WORD] Execute MailMerge in VB6 -
I am trying to use VB6 to open a MailMerge document.
This Word document is connected to a Text file as datasource.
When I try to open c:\source\letter1.doc, a message box will pop up:
Quote:
Opening this document will run the following SQL command:
SELECT *
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?