Connect to Access query from Mail Merge Wizard (Word 2002 sp1)

Topic

New Reply

Am I missing something? The new mail merge wizard in Word XP doesn’t seem to be able to connect with an Access query–only Access tables. It does allows me to choose a query only after choosing a table. No table is appropriate, but when I choose one at random to get to the option of choosing a query, I get an error when I choose the query I need. Is this correct, or am I missing something.

Reply | Quote

Replies

It is in there – what type of data source are you using in step 3?

Reply | Quote

Sorry abouy the time lag. Too many projects going on a once.

In step 3, I selected “using an existing list” and clicked on browse. It is an Access database that I connect to. Check the attached gif. Only tables are listed in the resulting dialog box. Yes, there are queries defined in that database. Any suggestions?

Reply | Quote

Try the following:
In Word, select Tools/Options…
Activate the General tab.
Tick the Confirm conversions at Open check box.
Click OK.
Now, go to step 3 of the Mail Merge task panel again, and browse to your database.
When you click Open, you will be presented with a list of choices; select MS Access Databases via DDE.
You should get a different dialog for selecting a data source, with separate tabs for tables and queries.

Reply | Quote

Are you by chance running Windows ME on your PC? We’ve seen some weird things with mail merges using Access, but they seem OK if you are running Windows 2000 or Windows XP.

Reply | Quote