Excel and Email Combo Question

[anixter employ 8331]

I have an excel list which includes name, address, catagory 1(etc.) for each line.
If I merge list to a Form Letter how do I send each letter (or page) of merged document to each indicated person via email.

I can also send the raw data to each person from the excel file. Each line item is a different person.
How do I get each line item to be sent to that person without the other people seeing data that isn't theirs?

 

[Dave Peterson]

In Word2002, there's an option under
Tools|Letter and Mailings|Mail Merge Wizard
for email messages.

Maybe you could use that.

And if you've never used mailmerge in word with your data in excel, you'll want
to read about it:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.