J
Jeff Cohen
I am trying to open a Word merge document based on a table from a function.
This is the code I am using:
Dim App As Object
Dim Location As String, FileName As String
Location = "C:\Documents and Settings\Jeff\My Documents\0 HRPA\George Mason\"
FileName = "Agenda.doc"
Set App = CreateObject("Word.Application")
App.Documents.Open Location & FileName
App.Visible = True
The document opens but it is not a merge document - all of the merge
functions (like merge to a new document) in the mail merge toolbar are greyed
out. If I open the document directly in Word it works fine.
This is the code I am using:
Dim App As Object
Dim Location As String, FileName As String
Location = "C:\Documents and Settings\Jeff\My Documents\0 HRPA\George Mason\"
FileName = "Agenda.doc"
Set App = CreateObject("Word.Application")
App.Documents.Open Location & FileName
App.Visible = True
The document opens but it is not a merge document - all of the merge
functions (like merge to a new document) in the mail merge toolbar are greyed
out. If I open the document directly in Word it works fine.