1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Automatic Outlook mail due date reminders based on Excel

Discussion in 'Business Applications' started by anusha.ankam, Jan 3, 2017.

Thread Status:
Not open for further replies.
Advertisement
  1. anusha.ankam

    anusha.ankam Thread Starter

    Joined:
    Jan 3, 2017
    Messages:
    2
    HI, Its my first post here. I need to send reminder mails from outlook based on excel reminder dates.
    For this i should not open excel neither i know VBA scritping for this.
    Please provide help on this.
    As i attached my file i need list of assets need to be calibrated ahead of 45 days of calibration due date.
     
  2. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,531
    First Name:
    Hans
    Hi, welcome to the forum.
    There are may posts with similar requests as well as automatic execution of similar scripts, have you at least searched for these?
    Excel has to be opened (even if it's in the background) and trigger mechanisms have to be present.
    I've helped with quite a few of these. I'll take a look if I can do anything for you, but I seriously suggest you do a search for all the options to automatically send a message based upon due dates. The automatic part I can help you with.
     
  3. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,531
    First Name:
    Hans
    May I point out that your file contains private data like email and phone numbers as well as names and so.
    Please ask a moderator to delete this file and you should replace the data with dummy data since it's only about the VBA code.
     
  4. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,531
    First Name:
    Hans
    I've attached a clean file with non-private data and the idea, not worked out yet.
    Oh yes, one thing, please do not use merged cells, it's terrible and a nightmare for programmers.
    I removed them and you can see for yourself that the result is the same bu at least you can work with the file now.
     

    Attached Files:

  5. eddie5659

    eddie5659 Moderator Malware Specialist

    Joined:
    Mar 19, 2001
    Messages:
    32,961
    Hiya

    I've removed the attachement you posted as it contained email addresses, phone numbers etc. If you want to upload a new one (or use the one that Hans attached), that would be great :)

    eddie
     
  6. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,531
    First Name:
    Hans
    Thanks Eddie, hope the poster appreciates it :)
    @anusha.ankam You have to give us more information like what does the email message have to say:
    Subject, message, etc. etc.
     
  7. anusha.ankam

    anusha.ankam Thread Starter

    Joined:
    Jan 3, 2017
    Messages:
    2
    Hi Han & Eddie,

    Thanks alot.
    Actually i have related posts but could not get any proper solution may be as i dont have proper knowledge on excel .
    Subject : Calibration due dates
    Email message : Calibration for below items is 45 days away. Please Check Equipment Calibration Excel for further details,
    XXX (From Excel)
    XXX (From Excel)
    XXX(From Excel)

    Thanks,
    Ankam Anusha
     
  8. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,531
    First Name:
    Hans
    I'll try and out something together and let you know.
     
  9. Keebellah

    Keebellah Trusted Advisor

    Joined:
    Mar 27, 2008
    Messages:
    6,531
    First Name:
    Hans
    Okay, I worked something out.
    The attached file contains a module named CheckandSendMailModule
    The macro to trigger it is named CheckAndSendMail
    If you Open Excel it will not send anything and you will have to trigger it manually
    The Macro named MailData requires parameters and takes care of sending the mail.
    You will have to edit this macro to actually send a message:
    Code:
        .Save           ' This property is used when you want to saves mail to the Concept folder
        .Display      ' This property is used when you want to display before sending
        ' .Send         ' This property is used if you want to send without verification
    
    You must place an ' in front of Save and Display and remove it where it says Send

    The result is as follows:

    A mail message with the subject: Calibration due dates
    And the message body
    The zip file also contains a vbs script, this file must be kept IN THE SAME folder as qhere you keep the Excel file and this file can be invoked daily using a scheduler to open the file and run the macro automatically

    The contents of the zip file:
    - EquipmentCalibradtion(SCADA).xlsm
    - CheckAndSendMail.vbs

    Hope you can get it to work.
     

    Attached Files:

  10. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1183282

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice