Regarding email notification in Excel 2010

Closed
Ansha_1 Posts 1 Registration date Wednesday October 23, 2013 Status Member Last seen October 24, 2013 - Oct 23, 2013 at 04:36 AM
 Blocked Profile - Oct 23, 2013 at 09:53 AM
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
Related:

1 response

Blocked Profile
Oct 23, 2013 at 09:53 AM
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
-1