Mail Merge Grouping

[Catherine.DeMayo]

I apologize if I amasking my question in the wrong formum. Anyway, I have a mail mergeproject. Mail merge standard emails I can handle no problem (at least Ithink). My question is I need to mail merge information to let's say anagent whose name is Desktop Agency. Desktop Agency has 5 overduereports due. My excel spreadsheet has 5 rows with a column for jobnumbers late and a column for Agent Name. Job numbers aredifferent. When I mail merge my emails, I end up with 5 different emailsas opposed to one email listing all 5 jobs which are late. How do Iachieve creating a merge to Desktop Agency listing all 5 jobs late in one emailrather than sending out 5 emails. Plus I need to use emails from a separate excel file. So, I will be using two spreadsheets to create one email (letter).