P
Phill
I am doing a mailmerge from Access (2000 format) to Word (Word 11 referenced)
and the connection is using DDE instead of OLE, resulting in the dreaded
opening of multiple instances of Access because I have changed the default
application title in the startup options. This is the code that I have:
'-- Create the OLE instance of Word, then activate it.
Set WordDoc = GetObject(strFinalDoc, "Word.Document")
WordDoc.Application.Visible = True
WordDoc.MailMerge.OpenDataSource _
Name:=CurrentDb.Name, _
LinkToSource:=True, _
ReadOnly:=True, _
SQLStatement:="SELECT * FROM tempMailMerge", _
subtype:=wdMergeSubTypeWord2000
WordDoc.MailMerge.Execute
Set WordDoc = Nothing
I don't want to use ODBC unless it is DSN-less. Also, the Word template
doesn't have any imbedded DDE connections. Any ideas?
and the connection is using DDE instead of OLE, resulting in the dreaded
opening of multiple instances of Access because I have changed the default
application title in the startup options. This is the code that I have:
'-- Create the OLE instance of Word, then activate it.
Set WordDoc = GetObject(strFinalDoc, "Word.Document")
WordDoc.Application.Visible = True
WordDoc.MailMerge.OpenDataSource _
Name:=CurrentDb.Name, _
LinkToSource:=True, _
ReadOnly:=True, _
SQLStatement:="SELECT * FROM tempMailMerge", _
subtype:=wdMergeSubTypeWord2000
WordDoc.MailMerge.Execute
Set WordDoc = Nothing
I don't want to use ODBC unless it is DSN-less. Also, the Word template
doesn't have any imbedded DDE connections. Any ideas?