Send email from excel that includes data from multiple rows/columns

[becky04]

Hi,

I want to be able to send an automatic email say every Sunday night at 1am so it is there for an employee on Monday to review.

I want the email to show which employees have expired tickets and which employees have tickets expiring in 30 days. I have set the cells to reflect that expired dates are in red and those expiring in 30 days are in green.

The email can be basic such as;

The following employees have tickets expiring within 30 days:
Employee first name, Employee last name
Employee first name, Employee last name
etc

The following employees have expired tickets on file;
Employee first name, Employee last name
Employee first name, Employee last name
etc

There are multiple columns for every employee but I am happy with something that acknowledges that if there is one or more red or green cells that that employees name can be included on the list that gets emailed.


Thank you for your help!
Becky

[becky04]

Ooh, I see my excel file is attached...for your reference ;-)

[zbor]

This thread is closed on the user request so it can be opened in Commercial services subforum.