Results 1 to 12 of 12

VBA to send emails based on Expired Due Dates (with Conditional Formatting)

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2018
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    Windows 7
    Posts
    6

    VBA to send emails based on Expired Due Dates (with Conditional Formatting)

    Hello!

    I'm a complete VBA newbie, and I'm attempting to create what is for me a quite complex macro for my bosses and I. I've already done the visual part of the report, but they also want the document to send emails via Outlook when any documents have their due dates expired. I'm on Office 16 btw.

    In my mind, it would go as follows:

    1. The macro would check in a range of cells (from F5 to N) if any of the documents are past their due date, whether by checking the date or seeing if the conditional formatting rules I've added (red filling, bold letters) affected any of these cells;
    2. If true, the macro would collect the document number(s) from the cell(s) in column A to add onto the body of the email;
    3. And then fill the "To:" field in the email with the owner of the document(s).

    I also thought of an alternative in which they would hit a button to make this check, and it would prompt a box instead. If there aren't any expired dates, the box would tell them. Otherwise, it would give them the option to send via email the number(s) of the document(s) with any expired dates.

    I've already searched the web for solutions, and I couldn't find anything. Maybe it's something very specific, so I'm hoping any of you guys can help me.

    Thanks in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Expiry dates - to send automated emails
    By jake.jay in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-26-2016, 03:48 PM
  2. Replies: 7
    Last Post: 02-24-2016, 11:34 AM
  3. Send Emails once expiry date is reached, and generate report based on emails sent
    By demonicscorpion in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 05:36 AM
  4. [SOLVED] Conditional Formating expired dates
    By Sandra_Sada in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-13-2014, 04:44 PM
  5. [SOLVED] Conditional Formatting highlighting expired dates
    By scolsen in forum Excel General
    Replies: 4
    Last Post: 01-13-2014, 01:33 PM
  6. Replies: 5
    Last Post: 12-31-2011, 04:33 AM
  7. Conditional Formatting in VBA for expired dates
    By xcelnerd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2010, 09:09 AM

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