Hi guys, I've been wracking my brain on this all last night. I need to create email mail merges to send out collections notices. But they want me to include the invoices pertaining to each client in the body of the email automatically.

Now I can create an excel table with customer, email address, and invoice#, but how do I get the Email merge to pick up only the invoices for a certain customer?

If I do it like a regular mail merge, it seems it will send out one email per invoice. But I need to group it by customer. Does that make sense?