Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE with Word
- Append Multiple Word Documents Together
- Change font in Word Document
- Change Font of Entire Doc File
- Change Margin and Fonts in Word DOC
- Changing Word Page Header
- Convert an RTF File to Plain Text file using Word
- Count bookmarks in Word
- Create a Word-document with table
- Create Hyperlinks in Word
- Extract Data from a Table in Word
- Extract Image from Word document
- Find and Replace Text in Word Document
- Find the Links in a Word Doc
- Get File Path to Word
- Get total number of pages
- Insert Text and CRLFs into a Word Doc
- Insert Wave File into a Word Document
- Inserting Pictures Into Table Cells in Word
- Mail Merge Warning in Word
- OLE and Word Basic Macro Language
- OLE and Word Example
- OLE Word File Append
- Print a MS Word document to to a PostScript printer
- Print an Envelope from Word
- Read Word Doc Line by Line
- Recordset to MS Word Table
- Run a Word Macro
- Setting Password in Word
- Spell Checker
- Template Info in Word
- Wait for Document to Load Completely
- Word - Constants
- Word Fields
- Word File Append
- WORD Find and Replace
- Word Mail Merge
- Word SaveAs HTML
- Word SaveAs
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Word Mail Merge
Keywords: Word Mail Merge OLE
Question:
Has anyone done anything with Word in automating a mail merge?Answer:
The following code works for me, as long as you have created a 'skeleton' word document with an appropriate input 'csv' file -
appWord = objectopen("Word.Application")
Documents = appWord.Documents
Documents.Open(skeletonDoc)
activeDoc = appWord.ActiveDocument
mailMerge = activeDoc.MailMerge
mailMerge.Destination = 0
mailMerge.Execute
oDOC = appWord.Application
oDOC.ChangeFileOpenDirectory(pathToSaveMergedDocIn)
activeDoc = appWord.ActiveDocument
activeDoc.SaveAs(nameToSaveMergedDocAs)
activeWin = appWord.ActiveWindow
activeWin.Close
activeWin= appWord.ActiveWindow
activeWin.Close
objectclose(mailmerge)
objectclose(activeWin)
objectclose(activeDoc)
objectclose(Documents)
objectclose(appWord)
Article ID: W15666
File Created: 2003:05:13:11:29:24
Last Updated: 2003:05:13:11:29:24