Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controlling Word from Excel using Mail Merge
I have an excel tracker that holds the datasource for Word mail merge. I want to tell control from excel though. How can I tell excel to open the word doc (which is already set to read that datasource) and merge? Here is the script that I am using to using the word document so far. Dim wdApp As Word.Application, wdDoc As Word.Document On Error Resume Next Set wdApp = GetObject(, "Word.Application") If Err.Number < 0 Then 'Word isn't already running Set wdApp = CreateObject("Word.Application") End If On Error GoTo 0 Set wdDoc = wdApp.Documents.Open("D:\Unique ID\My Mail Merge.doc") wdApp.Visible = True *What is the excel command to tell the word document to merge?* -- Tha BeatMaker ------------------------------------------------------------------------ Tha BeatMaker's Profile: http://www.excelforum.com/member.php...o&userid=23998 View this thread: http://www.excelforum.com/showthread...hreadid=379712 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge two excel files like in word mail merge | Excel Discussion (Misc queries) | |||
Excel to Word Mail Merge | Excel Discussion (Misc queries) | |||
Excel Mail merge two word | Excel Worksheet Functions | |||
word mail merge from excel | Excel Programming | |||
Mail merge from excel to word | Excel Programming |