+ Reply to Thread
Results 1 to 6 of 6

Excel Vba send email to multiple recipients for multiple ranges

  1. 09-14-2017, 09:09 PM #1
    Hoover5896
    Hoover5896 is offline
    Registered User
    Join Date
    07-08-2017
    Location
    Minnesota
    MS-Off Ver
    Microsoft Office 2016
    Posts
    74

    Excel Vba send email to multiple recipients for multiple ranges

    Hello,

    Below is a string to take the name in Column A, the email address in column B (recipient email address), and whether to send the email or not by "yes" or "no" in column C. The body of the email is in column G and then it sends an email.

    So far this macro will send the same email to all recipients. So if I have 10 different emails typed out in G1, G2, G3, G4, etc. The macro is taking the entire range G1:G20 and sending it.

    How do I make it so cell G1 is the email body for only cell B11 recipient? That way I can add a different email in cell G2 to go to the cell B2 recipient and so forth.

    Please Login or Register  to view this content.
    Thank you!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-15-2017, 11:46 AM #2
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Excel Vba send email to multiple recipients for multiple ranges

    Maybe
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
  3. 12-16-2017, 12:15 PM #3
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Excel Vba send email to multiple recipients for multiple ranges

    This version determines lastrow in Column G to skip empty rows.

    Please Login or Register  to view this content.
    Last edited by Tinbendr; 12-16-2017 at 12:27 PM.
    Reply With QuoteRegister To Reply
  4. 12-16-2017, 12:28 PM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Excel Vba send email to multiple recipients for multiple ranges

    What is the point of your question, please? The OP hasn't posted here since 01 December and this thread is marked as solved.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 12-16-2017, 12:31 PM #5
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Excel Vba send email to multiple recipients for multiple ranges

    Meant to respond to private email Decided to change to another solution.
    Reply With QuoteRegister To Reply
  6. 12-16-2017, 12:32 PM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Excel Vba send email to multiple recipients for multiple ranges

    Please do not take this conversation to private message - it's against the forum rules. Everything should stay here in this thread for the benefit of all - this is a public forum.

    Forum Rule #4: Don't Private Message or email Excel questions to moderators or other members. (or Word, Access, etc.) The point of having a public forum is to share solutions to common (and sometimes uncommon) problems with all members.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [Excel VBA]Parse & Send an email multiple worksheets to multiple recipients using Gmail
    By dylanrose in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2015, 06:01 AM
  2. [SOLVED] excel vba to send email to multiple recipients in CC
    By Kimston in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-01-2014, 07:03 AM
  3. send email to multiple recipients
    By plans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-18-2014, 09:26 AM
  4. send email from excel to multiple recipients
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-13-2013, 01:41 PM
  5. Use an array in excel 2007 to send email via lotus notes to multiple recipients
    By tknox827 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2012, 05:54 PM
  6. Send email to multiple recipients
    By Court16 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2009, 05:20 PM
  7. Send workbook via email to multiple recipients
    By lethal in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2008, 06:58 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1