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

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

"Philip" wrote:

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

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