Good Afternoon,

Here's the situation I have I'm hoping you can help me out. I have a list of several thousand records covering about 200 customers. I would like to do an E mail mail merge using the customer number and including specific information from those and send out only 1 E mail to each customer listing each item they purchased on its indival Mailing. Below is a really simplistic flow chart. Each line in the spreadsheet has the Item number and the customers E mail address each in their own individual cell...

Thank you in advance Dean

New Email
Customer 001
You have purchased


Item #1
Item #2
Item #3

New Email
Customer Number 002
You have purchased
Item #1
Item #3


Ect

This is a many to one mail merge. You can perform this type of merge with http://www.gmayor.com/ManyToOne.htm sending the reports either as attachments (in document or pdf format) to or as the body of the message.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com