Hi,

I need to configure the code below (which I borrowed from Paul here in the same forum).

The idea is for the code to read multiple cells (ex. D2 x F4). All cells that has a date that is "last 14 days prior to expiration" should
be included in a SINGLE E-MAIL along with the corresponding person who's carrying the ID and which Company it is.

For a better view of this:

A B C D E F

1 EmpID EmpName ContactNumber || Company1 Company2 Company 3
2 123 Vin 123456 24-Dec-12 21-Dec-12
3 124 Tom 123457 23-Dec-12 23-Dec-12
4 125 George 123458 20-Dec-12
5 126 Ana 212345 1-Dec-12


*imagining the date for today is December 15. All ID expiration dates will be included in the email, except for Ana, since they are 14 days before expiration date.

Mail should show something like this:

Attention:

Listed below are the Employees who have IDs due to expiration:

123 - Vin Company1 [24-Dec-12], Company3 [21-Dec-12]
124 - Tom Company1 [23-Dec-12], Company2 [23-Dec-12]
125 - George Company2 [20-Dec-12]

*or something like it. If possible to copy the selected cells and paste it in the e-mail automaticaly, that would be the best.

Thanks
Vin


Please Login or Register  to view this content.