Unanswered: Setting up Access or Word for a Mail Merge. I am having problems!!!
I want to use Mail Merge to take my Access Database and email a customer when their order has been confirmed. Here is how my data is stored:
Customer#___ Customer Name___ Order#___ Part#___ Price
1234567___ John Smith___ 987654___ part123___ $50.95
1234567___ John Smith___ 987654___ part678___ $23.95
6789101___ Sam Peters___ 766543___ part500___ $99.95
6789101___ Sam Peters___ 766543___ part901___ $101.00
I want it to show up in records for an email Mail Merge like this:
Dear John Smith,
Your order, 987654, has been confirmed. Here are the parts you purchased:
Can this be done? How can you tell mail merge to group off of a criteria like name or customer number? Right now, if someone ordered 15 parts, they will get 15 emails, confirming those 15 parts. That is BAD... Any help???