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
Bookmarks