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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Philip - 07 Jun 2006 16:21 GMT

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

Reply to this Message

Philip - 07 Jun 2006 16:33 GMT

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

> Hi All,
>
[quoted text clipped - 5 lines]
>
> pk

Reply to this Message

Peter Jamieson - 07 Jun 2006 17:14 GMT

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

> Hi All,
>
[quoted text clipped - 6 lines]
>
> pk

Reply to this Message