Access and Word Merge

[DSmith]

When I merge a query that has 888 records to Word in a mail merge, the merge
shows 0 records. Anyone know where to begin???? Haven't had this problem
before. Same query, same letter from last year, changed to XP. Help would be
greatly appreciated.

 

[Doug Robbins - Word MVP]

Probably - from the Tools menu, select Options and then on the General tab,
check the box against "Confirm conversions at open" Then when you attach
the datasource to the main document you will be prompted for the way in
which the connection should be made. Try the DDE option.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[DSmith]

It didn't help. But I found out the problem, although Access has no problem
with a wildcard in the critera, Word didn't like it. Once I got rid of the
wildcat, it worked fine. Thanks

 

[DSmith]

Just had to NOT use a wildcard in the query.

Probably - from the Tools menu, select Options and then on the General
tab, check the box against "Confirm conversions at open" Then when you
attach the datasource to the main document you will be prompted for the
way in which the connection should be made. Try the DDE option.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP