Email message with multiple records in the body of the message

[nancyma]

I want to use an Access table to send emails where I have multiple records for a single email and I want only one message with the multiple records in the body. I'm not good at VBA but I have someone in the office I can work with if necessary, and I'm very comfortable with Word mail merge to emails. Just can't figure out how to get a single email with multiple records in the body.

My table currently looks like this:

Employee	Email	Customer	Incentive Category	Amount
A	emp.A@coname.net	Customer A	Application	$50
B	emp.B@coname.net	Customer B	Application	$50
B	emp.B@coname.net	Customer B	Funded Loan	$125
B	emp.B@coname.net	Customer C	Application	$50

And I want an email to each employee that shows:
Dear Employee A:
You earned Incentives last month for:

Customer A	Application	$50
	Total	$50

-----------------------------------------------------------------------------------
Dear Employee B:
You earned Incentives last month for:

Customer B	Application	$50
Customer B	Loan Funded	$125
Customer C	Application	$50
	Total	$225

Thanks for your help! I'm currently manually creating about 40 emails every month -- what a time waster!

[June7]

The Word merge would require code that populates a table in the Word document. I know I've worked with another poster on this. Unfortunately, probably never find the thread.

An email from Access would build a single, long string by looping through recordset and concatenating data or by using HTML code tags to build an HTML table.

[NTC]

an alternative is to create an Access Report. the embedded feature of Access 2010 allows one to right click on that report when its open on your screen - and then select Email - and it will launch your email software to include the report as PDF file. It is a nice feature.