Mail Merge

[amavadia]

Hi, i have set up a mail merge between a query and a word document. My system is a system that processes transactions from an online cd shop. I have made it so that each cd that is bought by each customer is a different transaction in a transaction table, and each transaction is given an order number to group them. How do i get the mail merge to show all the transactions in an order on the invoice in my word doc because at the moment, even if i add two of the title name fields, they both show the same transaction.

 

[statsman]

Try using a query instead of the table.

 

[statsman]

Try using a query instead of the table as your data source.

 

[amavadia]

thats how i am doing it, the query is run, and then the records that are selected are mail merged

 

[statsman]

Hmmm...
When you run the query in Access, do you get the records you want?

Trying creating a report in Access using the query. If the Access report works OK it should be transferable to Word. If not, the problem is with your query.