How do you email to multiple recipients from spreadsheet?

[bovinda]

On a spreadsheet for a mailing list I keep, there is a column with people's email addresses. How can I send an email to all of the email addresses in that column? Or to just some of them? Clicking one opens up an Outlook email to the single recipient.

It'd just be nice if there was some easy, semi-automatic way to do this. It would be handy for the mailing list I manage.

Is there some obvious way to do this I am overlooking? Any help is greatly appreciated!

 

[Smitty]

Check out www.rondebruin.nl/sendmail.htm

Ron has all the Outlook code you need and I believe he covers how to multiple addresses in a range.

Hope that helps,

Smitty

 

[bovinda]

Smitty, that looks like exactly what I needed! Thank you so much, I never would have found that on my own.

Gratefully,
Jeff

 

[bovinda]

OK, on closer inspection, I think that I haven't yet found exactly what I need. Smitty's link, as far as I can tell, provides several scripts for sending out automatic, prewritten messages, or sending parts of a workbook.

I just need something that lets me select the column, and then allows me to open an email addressed to everyone in that column I selected (via Outlook, or whatever). That way I can write the text of the message specifically.

This would allow me to use the column like a mailing list. Is there some way to do that?

For example: I select cells B2-B5. Each of those has an email address in it. I want to be able to...do something...that lets me open up a blank email addressed to the email addresses in B2-B5. Is that possible?

Thanks all,
Jeff