recipients list is empty

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan - 31 Jan 2004 01:51 GMT

When I do a mail merge in word and try to use a query or
table from Access the list is empty. But if I open it in
Access the records are there. I have printed labels with
these tables and queries before. I tried making a new
data base and starting a new mail merge doc. Nothing
works. Help!!!!

Reply to this Message

Cindy M -WordMVP- - 02 Feb 2004 16:09 GMT

Hi Susan,

> When I do a mail merge in word and try to use a query or
> table from Access the list is empty. But if I open it in
> Access the records are there. I have printed labels with
> these tables and queries before. I tried making a new
> data base and starting a new mail merge doc.

Is this Word 2002 or 2003? And the version of Access is the
same?

From the context of your message may we assume that when
this was working, it was in an earlier version of Word?

Are you able to set up a link directly to one of the tables
used in the query? And do these records show up in the
Recipients list?

Open the query in Access and go into the SQL view. Please
copy what you find there (Ctrl+C) and paste it into your
reply so that we can see what kind of query this is.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

:-)

Reply to this Message

leigh - 12 Mar 2004 19:56 GMT

I've encountered the exact same problem. What's odd is that for me, it'
the queries that have wildcards "*" in them that are doing this. I'
still trying to figure out what's changed (service packs, machin
updates, network changes etc), but it was working about a month ago
Date stamps on the database query & word document indicate that n
changes hav occured since last fall. All of the software wa
originally imaged the same. But some PCs have had slightly differen
hotfixes applied to them over the last 6 months.

A work around for me was to hardcode the query (just to run letters fo
this morning). I still have to look through the knowledgebase, and
few other forums.. (I should have actually searched this one befor
posting on the first related one i saw :

Reply to this Message

leigh - 12 Mar 2004 22:28 GMT

Just tried this & it seemed to do the trick for me:

In word goto Tools->Options->General. Make sure "Confirm conversions
at open" is checked. This time when you select your datasource from
your .mdb file you'll be prompted to choose a connection method. Choose
"MS Access Database via DDE".

For me it seemed that the "OLE DB" method was not retrieving the query
results (which is what MS Access would have automatically choosen).

Hope this helps!

(for a detailed description of this & some other links you can go
here):
http://tinyurl.com/346qb

Reply to this Message