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.
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.
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.
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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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.