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 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!