Results 1 to 6 of 6

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

Threaded View

telcocook Macro to open Outlook and... 01-21-2015, 06:26 PM
daffodil11 Re: Macro to open Outlook and... 01-21-2015, 07:07 PM
telcocook Re: Macro to open Outlook and... 01-22-2015, 08:59 AM
daffodil11 Re: Macro to open Outlook and... 01-22-2015, 09:56 AM
telcocook Re: Macro to open Outlook and... 01-22-2015, 10:08 AM
daffodil11 Re: Macro to open Outlook and... 01-22-2015, 10:11 AM
  1. #1
    Registered User
    Join Date
    09-10-2014
    Location
    Lexington, KY
    MS-Off Ver
    2021
    Posts
    45

    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

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