+ Reply to Thread
Results 1 to 2 of 2

Mail based on dates

  1. 07-09-2018, 03:58 PM #1
    Jamesraywebber85
    Jamesraywebber85 is offline
    Forum Contributor
    Join Date
    02-12-2018
    Location
    Clearwater, FL
    MS-Off Ver
    MS 365
    Posts
    214

    Mail based on dates

    I have a sheet called "TSA Request" that has a cell in F32 - where an agent puts an email address. Is it possible to have a code that states if the value in cell "F9" is less than 30 days then email to me & the value in cell F32. If F9 > 30 days then just email me. I have attached my workbook for any help you can provide & I have included the code that I am using for the email. Thank you in advance for any help you can provide.
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-09-2018, 08:29 PM #2
    Kenneth Hobson
    Kenneth Hobson is offline
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,573

    Re: Mail based on dates 

    Please Login or Register  to view this content.
    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. Find count of dates based on between two dates and update dates in another cell
    By senthile in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-20-2018, 11:52 AM
  2. Mail variable number of sheets in workbook based on VLOOKUP mail address
    By Tino XXL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-08-2013, 08:44 AM
  3. Need Macros to send standard e-mail based on dates
    By jameslav2003 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2013, 11:10 AM
  4. [SOLVED] Auto filling dates based on previously entered dates and averaging numbers if dates equal
    By grambograham in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2012, 03:21 PM
  5. How to e-mail selected row and use e-mail address in a cell to send e-mail from excel
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2010, 02:15 AM
  6. Automatically send Mail for Due Dates from Excel
    By Kohinoor in forum Excel General
    Replies: 1
    Last Post: 03-20-2009, 12:10 PM
  7. E-mail notifications from Excel based on dates in speadsheets
    By DWBAUS in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-23-2006, 12:45 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