Results 1 to 1 of 1

Thread: VBA to Send Different Emails Based on Criteria

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Junior Member
    Join Date
    Aug 2018
    Posts
    12
    Rep Power
    0

    VBA to Send Different Emails Based on Criteria

    Hello,

    I have a spreadsheet I'm using to log data request emails I send to my clients. I have 4 columns:

    A: Name
    B: Email Address of Client
    C: XXX (data needed)
    D: First Request Date
    E: Second Request Date

    What I'd like to do is this:

    If column C is blank, send an email that says "Hello - Please send me (XXX) at your earliest convenience. Thanks!", then log today's date in column C

    If column C is NOT blank, and more than 14 days have gone by, reply to the original email thread and send email that says "Hello - We are following up as we still haven't received (XXX). May you please at your earliest convenience? Thanks!"

    Is there a way to do this in one macro instead of two?

    Thanks!

    -Patrick


    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://www.youtube.com/watch?v=oVb1RfcSHLM&lc=UgwTq-jZlZLnLQ5VB8Z4AaABAg.9Hroz-OyWog9tYjSMc1qjA
    https://www.youtube.com/watch?v=0pbsf6sox34&lc=Ugxp9JFvvejnqA68W1t4AaABAg
    https://www.youtube.com/watch?v=kfQC-sQxMcw&lc=UgyCxQWypNIhG2nUn794AaABAg.9q1p6q7ah839t UQl_92mvg
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgyOh-eR43LvlIJLG5p4AaABAg.9isnKJoRfbL9itPC-4uckb
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugy1B1aQnHq2WbbucmR4AaABAg. 9isY3Ezhx4j9itQLuif26T
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgxxajSt03TX1wxh3IJ4AaABAg. 9irSL7x4Moh9itTRqL7dQh
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=Ugxa2VYHMWJWXA6QI294AaABAg. 9irLgSdeU3r9itU7zdnWHw
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgwJAAPbp8dhkW2X1Uh4AaABAg. 9iraombnLDb9itV80HDpXc
    https://www.youtube.com/watch?v=vXyMScSbhk4&lc=UgzIzQ6MQ5kTpuLbIuB4AaABAg. 9is0FSoF2Wi9itWKEvGSSq
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 09-22-2023 at 04:06 PM.

Similar Threads

  1. Replies: 3
    Last Post: 02-09-2019, 08:44 AM
  2. Replies: 2
    Last Post: 08-10-2016, 04:59 PM
  3. Replies: 0
    Last Post: 08-04-2015, 11:08 PM
  4. Replies: 3
    Last Post: 06-25-2013, 07:51 AM
  5. Replies: 6
    Last Post: 06-05-2013, 11:33 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •