Why DDE connection?

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top