Using Access queries to do a Merge to Word in XP

[John Baker]

I have been using a method to automate the word merge from an Access query.
This has worked wonderfully well in Access97, 2000 and XP. However I have
hit a stumbling block when the merge is to WordXP. My method is to just
automate what a user would do to use from the menu: Tools/Office Links/Merge
It With MSWord

Now using WordXP the merge doesn't complete. Instead it shows a dialogbox
asking to "Select Table". It shows a list of all tables and some (but not
all) queries. The queries have the type "Views" in the listbox. The queries
I want to use are not in the listbox.

When I open a query in access and then try to use "Tools/Office Links/Merge
It With MSWord" the query does not seem to link to WordXP in the way
previous versions of Word would do automatically. Instead it asks to
"Confirm the Data Source". No matter what I try here I cannot seem to get it
working.

Can anyone put me on the path to overcome this problem?

Any help greatly appreciated.

John Baker
(e-mail address removed)

 

[SA]

John:

I find too that the new merge and data source wizards are fraught with
problems and difficult to use in Xp forward. Normally if using a query as a
data source then we find that a DDE connection type will work most smoothly
(unless you are doing this via code, when in we'd suggest an ODBC system
connection). You can target the specific query to use by selecting it in
the Access db window before you choose to merge it with Word.

 

[Ragnar Midtskogen]

John,

Another route is to export the data to a text file, choosing to output the
field names as the first record in the text file. Then use it as the data
source when doing the merge from Word.

Ragnar