Notification from Excel to e-mail automatically
Hello !
how to set notification from excel to microsoft outlook ?
The scenario is like this ,
i have spreadsheet which has to be checked every bi weekly. my boss needs me to create a notification system from that spreadsheet, i.e for every bi-weekly , it should send an e-mail to the specific people to check the spreadsheet automatically :( I tried many things like setting up timer in VBA. it didnt work out, and i didnt know how to connect automatically to the mailing system. Please can one help me out to find a solution !
Thanks in advance
Indhira
P.S : I have attached the Excel file with this query
Attachment | Size |
---|---|
Regulation and Document Control.xls | 36.5 KB |
Code to send email
Check this url:
http://excelexperts.com/Outlook-Email
where to put this code ?
Hallo friend !
Thanks for the reply !
Can u pls suggest me where should i use this code? in VBA ?? or macro ??
i need to set a timer for every bi-weekly before i set this notification ! :(
I thought I can write a code for Timer in VBA
Kindly reply
Thank you
Indhira
You can use the following
You can use the following line of code to run a specific macro at the specified time.
Change the time and macro name as per you requirement....
Application.OnTime TimeValue("17:30:00"), "MacroName"
You can put this line of code in Workbook open event. The workbook needs to be open for the above piece of code to take effect.
thanks a lot !
thanks a lot !