+ Reply to Thread
Results 1 to 6 of 6

Macro to open Outlook and send one email to multiple addresses from excel columns

  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2013
    Posts
    39

    Macro to open Outlook and send one email to multiple addresses from excel columns

    Hello.

    I would like help to create a macro to send (1) one email to multiple email addresses found in a worksheet. This macro should be able to open Outlook if it's not already opened, populate the 'To:' field with all the emails addresses that match the criteria noted in the attachment. I will then manually enter the subject and body of the email to complete sending it.

    I have attached a workbook to show that only rows with the word 'yes' in column E should be used to send emails to the addresses in column C and D.

    It would be handy to have a button in the worksheet to invoke this macro but if too much trouble then not a big deal.

    Thank you so much for all of your help and suggestions.
    Attached Files Attached Files

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Macro to open Outlook and send one email to multiple addresses from excel columns

    Here's some code you might try. To button-ify, just go to Insert->Shapes and put a little shape or use some unicorn clip art in the upper left corner, and right-click assign macro and choose this one.

    Please Login or Register  to view this content.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2013
    Posts
    39

    Re: Macro to open Outlook and send one email to multiple addresses from excel columns

    Wow! Thanks a bunch daffodil11. Can you tell me what I might change in the code to open only (1) one email message for all email addresses? Also, it would be good if the emails going to the 'cc:' are actually going to the 'to:'. all email addresses with a 'yes' in their row should go in the 'to:' field in Outlook.

    Thanks again!

  4. #4
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Macro to open Outlook and send one email to multiple addresses from excel columns

    Ahh, so you want to only generate a single email, and send it to every email address.

    I pulled the logic from this post.

    We just put the loop up front, and build a single entity "sendTo" which is a concatenation of all the email addresses. Then we generate the email, and apply them all at the same time.

    Tested and verified.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2013
    Posts
    39

    Re: Macro to open Outlook and send one email to multiple addresses from excel columns

    So Cool! That works exactly like I was hoping it would. I hope others can find this code helpful for themselves as well.

    Thank you daffodil11! ... and Thank you Excel Help Forum!!

  6. #6
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,468

    Re: Macro to open Outlook and send one email to multiple addresses from excel columns

    Glad I could help out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel macro to send email through outlook when expiry nearing
    By bqheng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-17-2014, 08:07 PM
  2. Macro to send notification from excel to my Outlook Email
    By savethisid in forum Excel General
    Replies: 18
    Last Post: 03-27-2014, 02:25 PM
  3. [SOLVED] Need help in editing the current Macro to send email with multiple attachments frm Outlook
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2014, 11:25 AM
  4. Replies: 2
    Last Post: 04-27-2012, 03:53 AM
  5. Open Outlook and send email
    By linsonline in forum Excel General
    Replies: 2
    Last Post: 05-06-2011, 09:29 PM

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