Sending to Multiple Email Addresses From Cells

**The Flightless Kiwi** · 04-05-2009, 05:04 AM

Hi, I'm new to this site. It looks great. Sounds like you all have lots of experience.

I'm a primary school class representative and I want to create an excel contact list of the parents email addresses so that I can click a button, it will open the default email (in my case MS Outlook) and then populate the "To" email address field with the email addresses (separated by a comma).

Can anyone provide me the VB code that I can paste into my worksheet VBA that will look at a range of cells (say E2:E30) that contain email addresses, and put them in the "To" field of a blank email?

I have put a button on the page and it's called "EmailButton" but I don't know what VB to put with it. I'm using MSExcel 2007 (at home) and 2003 (at work)

Thanks

**oldchippy** · 04-05-2009, 05:15 AM

Hi,

Welcome to the forum, take a look at Ron de Bruin's site here

http://www.rondebruin.nl/sendmail.htm

**The Flightless Kiwi** · 04-05-2009, 05:51 AM

I found that the fiorst example on this link was the closest http://www.rondebruin.nl/mail/folder3/message.htm The only change I did was remove the ".Send" and change to ".Display" so I could edit the email prior to sending. This works great for heaps of emails that get sent one at a time. I want a group type email.

If I want to bring up ONE blank email with all the recipients in the "To" field. And the recipient email addresses were all contained in a range (Say E2:E30), what would I need to midify for the above code to work?

Thanks again - I'm nearly there

**oldchippy** · 04-05-2009, 02:28 PM

Hi,

On the link in your post, there is this other link, hopefully that will help?

Check out this page for Tips If you want to change the code on this page.
http://www.rondebruin.nl/mail/tips2.htm

**The Flightless Kiwi** · 04-06-2009, 04:26 AM

SOLVED - Thank you old chippy!

This works a treat. Here's the finished code. It's not tidy as it's a mish mash of bits but it works!!

Please Login or Register  to view this content.

**oldchippy** · 04-06-2009, 06:13 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

**tate2133** · 02-03-2010, 06:58 PM

Is there a way to make that work with gmail?

**DonkeyOte** · 02-04-2010, 04:21 AM

tate2133,

Your post does not comply with Rule 2 of our Forum RULES.

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

You have a thread open on this topic, please stick to it.