+ Reply to Thread
Results 1 to 5 of 5

Sending Emails based on Check Boxes

  1. 02-15-2017, 06:48 PM #1
    rwl123456
    rwl123456 is offline
    Registered User
    Join Date
    02-14-2017
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Sending Emails based on Check Boxes

    Hi Everyone,
    I am working on a file that will send an email to each person that has a checkbox marked. The code below and the workbook attached is where I am at. Currently it is sending emails to the full list. I have not been able to successfully add in for it to only send to the rows that have a checked box/ TRUE in column I23. What is the best way to approach this? I'm a beginner with the VBA world so have been learning a lot but this has left me stump.


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by rwl123456; 02-16-2017 at 12:11 PM.
    Reply With QuoteRegister To Reply
  2. 02-15-2017, 08:12 PM #2
    humdingaling
    humdingaling is offline
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Sending Emails based on Check Boxes 

    Please Login or Register  to view this content.
    seems like you have the checkboxs linked to column I
    as such you only need to add if statement to check cell in column I to see if true
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 02-15-2017, 08:43 PM #3
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Sending Emails based on Check Boxes

    Hi rwl123456

    Welcome to the Forum!!!

    Try this Sub SendEMail() Code...

    Please Login or Register  to view this content.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    Reply With QuoteRegister To Reply
  4. 02-16-2017, 12:11 PM #4
    rwl123456
    rwl123456 is offline
    Registered User
    Join Date
    02-14-2017
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Sending Emails based on Check Boxes

    Thanks! your responses have been extremely helpfully the solutions seem so obvious and simple once you see them! In my head I was thinking how complicated it may be to link the two together.

    Solved!
    Reply With QuoteRegister To Reply
  5. 02-16-2017, 02:45 PM #5
    jaslake
    jaslake is offline
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Sending Emails based on Check Boxes

    You're welcome...glad I could help.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
    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. Sending emails based on two spreadsheets
    By VORT8019 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-09-2014, 11:06 AM
  2. I need a code for presence check to check multiple text boxes and combo boxes
    By Lee_wwfc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2013, 01:53 PM
  3. [SOLVED] Sending Outlook emails from Excel; Limits to three emails only?
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2013, 06:53 AM
  4. Sending Emails from excel based on deadline dates stored in file
    By williery10 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-04-2012, 01:00 PM
  5. Automatic setting of check boxes based on other check boxes?
    By ArchiveMike in forum Excel General
    Replies: 5
    Last Post: 07-31-2012, 09:43 AM
  6. Sending macro emails using excel: Send emails with their passwords.
    By loveisblind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2009, 03:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1