Problem w/ mail merge of 2 linked tables in Access 2003 to MS Word

D

Deb

Background: 2 tables linked (main table contains customer data, 2nd table
contains multiple conditions linked to that customer and they are linked by a
unique id # that Access assigns).

I've run a query in Access to use for my mail merge in MS Word. Everything
works great, EXCEPT....if one customer record has multiple conditions, only
the first condition shows up in the merge letter. Any additional conditions
show up as separate letters. I need to be able to have 1 letter that lists
all of the conditions that exist for that customer.

What am I doing wrong?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Word Mail Merge from MS Access Query 2
Word merged with Access 3
mail merge with Word and Access Query 0
Multiple Donations - Mail Merge 11
Mail Merge - List multiple items then page break on unique data 1
Directory Mail Merge with table layout 2
Mail Merge Word Doc over SSL VPN 0
Microsoft Access feeding Word Mail Merge 0

Top