Multiple Lines on an Invoice

[risnasmhd]

Mail Merge - Multiple Lines on an Invoice Friendly-reminder-email-.doc



Masterdata.xls

I was asked this question, and I am at a loss. A user has an Excel file that lists customers and the services they buy from us (each service has a Service Number). She uses this spreadsheet to merge to Billing letters/invoices in Word. Right now, when she merges, it creates a separate letter/invoice for each customer for each service... John Smith might have 15 services, so he is getting a separate letter for each service.

Yuck. She wants to set it up so that John Smith would receive ONE letter that lists all 15 of his services. Maybe the next customer, Susy Johnson would have 1 service, so she would receive one letter for her one service. The next customer might have 4 services... so he'd need ONE letter listing all 4 services.

See what we're trying to accomplish?

How can we tell Word that at every break in Customer Only, we need a new letter, otherwise, just list the services for that customer on one page??

Thanks!