Word 2003 Merge won't show data in Access Query?

[Philip]

Hi All,

Not sure what I'm doing wrong. When I create a email merge form letter
linked to a Access 2003 query, none of the data shows. Everything is blank.
Yet, when I look at the query in Access, there's plenty of data.

Any suggestions?

pk

 

[Philip]

I should mention that when I export the query to an Excell file, everything
works fine.

 

[Peter Jamieson]

If your query uses wildcards (*,%,_ or ?) then there can be a mismatch
between Word/Jet/Access. In that case the quickest fix is probably to check
Word Tools|Options|General|Confirm conversions at open, go through the
connection process agai, and try the DDE option when offered. it will cause
Access to open, which can be a pain if you are setting this up for others to
use, but is usually not too problematic if you're just doing the merge
yourself.

Peter Jamieson