Mail merge from Access to Word

[Penny]

HELP! I used to consider myself pretty good at mail
merges, but since using XP, there is either something
badly wrong with me or hopefully I can blame my tools.

After creating a mail merge main document by using the
Access "merge it with word" link, I find that my data
source is empty, although it does exist in the query
table still within Access. Anyone know what I am doing
wrong, please?

Thanks
Penny

 

[Peter Jamieson]

Word XP connects to Access using a different default mechanism (OLEDB) than
the older versions (DDE). When using OLEDB, it won't even connect to some
types of query. I'd suggest you either revert tot he old method or try
ODBC - check Word Tools|Options|General|"Confirm conversion at open", go
through the connection process again, and select either DDE or ODBC when
prompted.