View Single Post
  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
 
Posts: n/a
Default Word 2003 Merge won't show data in Access Query?

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

"Philip" wrote in message
...
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