E-mailing a list to multiple recipients?

Hi!

How do I e-mail a list to multiple recipients? I've got a long row of e-mail adresses and a list under each in each row. How do I go about this? (probably using the merge function, but HOW? (Excel 2003)

I only want to send ONE individual e-mail to each person. Each email shall only contain the names in the column under each email address. The recipients should not know about each other nor what is in each others e-mails

Originally Posted by Rahul Nagar

Put all email address in BCC column

Thanks, but the list is different for each email. Each COLUMN has an email as a header/title, and a list under it of names which should be sent to that person.

Originally Posted by teylyn

Hello,

why not use Word Mail merge to email with Excel as the source?

cheers,

Thanks!!
This is what i've been trying, but I can't figure out the specifics of this operation. I can only do it with the email addresses in one column and each of the names in the list in its own separate column... Which would make it like 10000 columns =/

Any tips on this?

Originally Posted by teylyn

check out this article by Cindy Meister

http://homepage.swissonline.ch/cindy...r/MergFram.htm

Go to Special Merges > Multiple items per condition.

Not trivial, but can be done.

Thank you! This definitely put me on the right track. I found an updated version of the best of the links on Cindy Meisters page:
http://support.microsoft.com/kb/294686

However, I fail to put a merge field in the "to" field under the email button? is this even possible?

This article suggests putting multiple e-mail addresses in the same column in order to merge. Then using IFs to avoid multiple entries and such.

Originally Posted by teylyn

When you mail merge to email you can only ever have one recipient per email. That's the email address, which can be a field in your Excel source table.

Won't this send multiple emails to the same recipient?

I solved this by creating a list with only one email and using a mixture of count and if to make a long row of names next to it..
Then using email merge as usual.

Kinda tricky =P