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

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?