Closed Thread
Results 1 to 8 of 8

Sending to Multiple Email Addresses From Cells

  1. #1
    Registered User
    Join Date
    04-05-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    3

    Sending to Multiple Email Addresses From Cells

    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
    Last edited by The Flightless Kiwi; 04-06-2009 at 05:42 PM.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Sending to Multiple Email Addresses From Cells

    Hi,

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

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


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    04-05-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Sending to Multiple Email Addresses From Cells

    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

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Sending to Multiple Email Addresses From Cells

    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

  5. #5
    Registered User
    Join Date
    04-05-2009
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    3

    Thumbs up Re: Sending to Multiple Email Addresses From Cells

    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.
    Last edited by davesexcel; 09-30-2019 at 09:38 AM.

  6. #6
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097

    Re: Sending to Multiple Email Addresses From Cells

    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

  7. #7
    Registered User
    Join Date
    02-03-2010
    Location
    US
    MS-Off Ver
    Excel 2002
    Posts
    11

    Re: Sending to Multiple Email Addresses From Cells

    Is there a way to make that work with gmail?

  8. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Sending to Multiple Email Addresses From Cells

    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.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1