Hello,

I have a report that needs to be run daily. I have to then have to send an email to the individuals that are responsible for the areas that the report has flagged. There are 75 total possible people to send to, but not all get an email each day. Looking for a way to save some time.

Is there a way I can correlate the location name to each person's email that is responsible for that location and the have excel create the outlook mail message and send that to each person.

Any idea's would be greatly appreciated.

Thanks,