How do you email to multiple recipients from spreadsheet?

bovinda

Board Regular
Joined
Jun 11, 2005
Messages
87
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!
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

bovinda

Board Regular
Joined
Jun 11, 2005
Messages
87
Smitty, that looks like exactly what I needed! Thank you so much, I never would have found that on my own.

Gratefully,
Jeff
 

bovinda

Board Regular
Joined
Jun 11, 2005
Messages
87
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
 

Forum statistics

Threads
1,136,990
Messages
5,678,985
Members
419,797
Latest member
ikethegenius

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top