+ Reply to Thread
Results 1 to 3 of 3

VBA that needs minor tweak to send to multiple email addresses

  1. #1
    Registered User
    Join Date
    09-20-2013
    Location
    Hartland, WI
    MS-Off Ver
    Excel 2013 Professional Plus
    Posts
    73

    VBA that needs minor tweak to send to multiple email addresses

    I have a code that sends out multiple emails all with different ranges as attachments from one spreadsheet. It works perfectly, however, I can only get it to send to one email address at a time. I would like to be able to send each range to up to 3 email address at the same time. I am still a beginner with VBA, so any help would be appreciated. I would like each email to be in the TO: section, but it would not kill me to put one in TO:, one in CC:, and one in BCC:. Thanks.

    Please Login or Register  to view this content.
    Last edited by gillyr7; 02-06-2014 at 10:56 AM.

  2. #2
    Forum Expert
    Join Date
    06-25-2009
    Location
    Sofia, Bulgaria, EU
    MS-Off Ver
    Excel 2003-2013
    Posts
    1,290

    Re: VBA that needs minor tweak to send to multiple email addresses

    Hi,
    As it is, the code reads the e-mail address form column N:

    Please Login or Register  to view this content.
    you can add all 3 e-mails in a single cell, separated by commas

    or tell us from where it will read the other 2 in order to amend the code.
    If you are pleased with a member's answer then use the Star icon to rate it.

  3. #3
    Registered User
    Join Date
    09-20-2013
    Location
    Hartland, WI
    MS-Off Ver
    Excel 2013 Professional Plus
    Posts
    73

    Re: VBA that needs minor tweak to send to multiple email addresses

    I did not know it could do that. That works perfect. Thank you for the answer.

+ 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. Replies: 1
    Last Post: 09-09-2013, 03:46 PM
  2. [SOLVED] Minor tweak to this macro required to get it just right - how to do it?
    By cronshd in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-29-2012, 03:08 AM
  3. How to send the same form to different email addresses using macros?
    By kjdemeyer in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2009, 03:06 PM
  4. Newby Needs minor tweak on this VBA Macro code for Excel
    By zulfer7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2006, 12:35 AM
  5. [SOLVED] send email with email addresses in a range of cells
    By Craig in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2005, 05:05 PM

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