Results 1 to 2 of 2

Thread: Macro to trigger emails based on dates

  1. #1

    Macro to trigger emails based on dates



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi!

    I would like to know if anyone could help on my issue.

    It's that I need to send emails to a certain set of email contacts based on the dates mentioned in an excel file. The dates correspond to deliverables that are due, but have/have not been submitted on those respective dates. The file can be sent to you if you would like to review the same. A preceding email message would also need to go in the auto-email.

    Trailer no. Item Activity Due Date 1st delayed date 2nd delayed date 3rd delayed date Total days of delay Status
    A Tank Detailed design 26/12/2014 04/01/2015 Received on 20/12/2014
    A Tank Tank GA drawing 16/12/2014 19/12/2014 23/12/2014 24/12/2014 8
    A Tank Detailed drawings 15/12/2014 20/12/2014 received on 21/12/2014
    A Trailer Detailed design 16/12/2014 19/12/2014 23/12/2014 24/12/2014 8
    A Trailer GA drawing 15/12/2014 20/12/2014 31/12/2014
    A Trailer Detailed drawings 16/12/2014 19/12/2014 20/12/2014 03/01/2015 18
    B Vessel Detailed design 15/12/2014 20/12/2014 received on 21/12/2014
    B Vessel Tank GA drawing 16/12/2014 19/12/2014 23/12/2014 24/12/2014 8


    The email message would read something like this:
    Dear Team,

    Below is the list of delayed Activities of the project as of today, 042 Jan 2015.
    Total delay on each item is also highlighted. Please submit the pending documents without further delay.
    Trailer no. Item Activity Due Date 1st delayed date 2nd delayed date 3rd delayed date Total days of delay Status
    A Tank Detailed design 26/12/2014 04/01/2015 Received on 20/12/2014

    Best regards,

    In other words, the email would extract the content of the rows where the macro has identified delay based on the current date.

    Is there a macro you could help me with to make this possible?

    Thanks so much for your assistance.

  2. #2
    Seeker DSDressler's Avatar
    Join Date
    Dec 2014
    Location
    Bend, OR
    Posts
    18
    Articles
    0
    Guess you can do it with a macro but why not just do a mailmerge? Use your excel file as the data file. Start Word, create a new main doc or use a form template and open your existing Excel file as the data doc. Filter the date/s you want and Finish & Merge.Send Email Message and use a data column in your Excel doc that contains the email addresses.

    If this seems workable it might save some time and heartburn. I've done this so if you need more info, let it be known...

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
  •