+ Reply to Thread
Results 1 to 1 of 1

Loop through all sheets & if cell is blank then send email

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    Loop through all sheets & if cell is blank then send email

    I have a workbook that we use as a tracker. All the tabs (except the 1st one) is a month. What I need is a code to loop through each monthly sheet & if E3:"last row" is blank then generate an email with the TO: person would be the value in column B of that row. Once the email is sent then it would put in the cell in column E, "Coached on "Date" & Time that the email was sent. Any help would be greatly appreciated & I have attached a copy of my workbook so you can have a visual to assist. Thank you very much!
    Attached Files Attached Files
    Last edited by Jamesraywebber85; 05-02-2019 at 04:38 PM. Reason: left personal info in vba code

+ 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. [SOLVED] Code to send email & loop through sheet
    By Jamesraywebber85 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-16-2018, 08:31 PM
  2. while loop to check value condition and send email
    By mo7al-sa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2018, 08:36 AM
  3. Send a single email to multiple contacts using a loop
    By bn06a2b in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-01-2014, 07:48 AM
  4. Workflow with signatures (if cell=x then send email, if signed then send email)
    By Kate2811 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2014, 05:37 AM
  5. Loop cell to create PDF and send as email in lotus notes
    By Mark Brown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-11-2011, 06:12 PM
  6. Loop through autofilter and send via email to address in column L
    By madamson86 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-02-2010, 10:01 AM
  7. [SOLVED] Loop through email address list to send e-mails
    By Paul. in forum Excel General
    Replies: 1
    Last Post: 04-12-2005, 08:06 AM

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