View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Dixie Dixie is offline
external usenet poster
 
Posts: 22
Default How do I establish an OLE DB connection for an mde database?

I am having problems mailmerging with text files sent out to the local drive
from within Access 2003, then having word documents target them for the
merge data. The mailmerge templates seem to lose their target after a while
for no apparent reason - no idea why.

I tried to include the path to the mailmerge data in the VBA code in Access
that opens the word template. It worked fine for an mdb database, but when
I compiled it into an mde, it did not.

I am definitely no expert in this area, but is this due to the wrong
connection method? I think DDE is being used by the program - it is
programmed in Office 2000, but being run on Office 2003.

dixie