Hi,

I am new to this forum and have been going through some of the posts

I am looking for advice:

I require a VBA that looks at a specific date in a cell on the active sheet and then send a mail (OUTLOOK) to a specific person who the line is assigned to. the date and person will be in the same row and the columns will be next the each other.

I know there is a lot of other threads with the same question, but I need some guidance.

Also, is it possible for a VBA to work if the ECXEL is not open?

Scenario: We have an excel spredsheet that is used by +/- 35 users. The document is on a sharepoint server. I need this document to be e-mailed every day at a specific time to a number of personell. OR is it possible to send an individual mail to a specific person that the line is directed to. For instance, if Megan needs a product from Steven, she will fill her information into the spreadsheet and will make him the responsible person. When she saves the document an e-mail must go out to Steven on any lines that does not have info in.

Background: We have about +/-20 sales coordinators that will request a specific action from +/- 15 planners.

Hope some can help me

Thank you