Macro to trigger emails based on dates

LalaineCruz

New member
Joined
Jan 4, 2015
Messages
1
Reaction score
0
Points
0
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.
 
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...
 
Back
Top