Word mailmerge automation

B

bernie69

Hi,

I have an Access 2003 database. In one of its forms is a pushbutton which
starts a Word mailmerge via VBA automation. It works fine with Access 2007
aand Word 2007. Once I convert the access database to the new 2007 format
(accdb extension), the automation quits working. The odbc driver can't login
and is looking for a non-existing database.

Any ideas?

The code I use and which stalls the prg is just standard:

objWord.MailMerge.OpenDataSource Name:=CurrentDb.Name, _
LinkToSource:=True, _
Connection:="QUERY NameofQuery", _
SubType:=wdMergeSubTypeWord2000

Many thanks
 

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

Similar Threads

VBA - Word automation (mailmerge) - convert access 2007 3
Access 2003 to Word 2003 Mailmerge very slow 6
Word Table saved as ActiveX in Access, how to display in Word 0
Mail Merge Functionality 0
Mailmerge recepients list blank (pulling from Access query) 0
How to Control Which Printer MS Word Prints To 1
Automating MailMerge from Access - Word unable to open datasource 0
Mailmerge from Word 2003 using 2000 word template 6

Top