Hello,
We have an aging report in Excel that shows invoice approvers and how many invoices they have yet to approve. There could be up to 6000 invoices, but not 6000 approvers as each approver could have 1 or 50 invoices they have not approved. We have a Word template and use an email merge, but that is a one to one merge resulting in one approver getting multiple emails...one for each outstanding invoice. Is there a way to group all their invoices like shown below so they only get 1 email? I've searched the web and did find a mail merge grouping using the type directory, but not email. We do have duplicate names, but their employee id is unique.
Appreciate any help!
Cathy
EXAMPLE
SUPPLIER INVOICE AMOUNT #DAYS
----------------------------------------------------
ABC TECH 12345 100.00 10
TECH ONE 23456 200.00 15
A-1 TECH 34567 300.00 25