Regarding email notification in Excel 2010

[Closed]
Report
Posts
1
Registration date
Wednesday October 23, 2013
Status
Member
Last seen
October 24, 2013
-
 Blocked Profile -
Hello,
I am preparing a sheet for my company leaves and in this sheet I want users to put their leave date and once they make changes in the leave it should go to their respective managers email id .Managers email id is mentioned in one of the column in Excel.

Can you please let me know how I can create Macros for sending email notification to respective managers mentioned in one column after saving the sheet?

Your quick response will be really helpful.

Thanks & Regards,
Ansha Agrawal

1 reply


Good Morning.

Give this link a try, we worked on this in August.....

It is realy just an example of how to construct a mail object within excel. You must modify for your application.


https://ccm.net/forum/affich-717183-code-for-the-below-scenario-excel-vba

Please post back if any questions....

Have Fun!
//ark
-Contributor