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

AttachmentSize
Regulation and Document Control.xls36.5 KB

Code to send 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

Vishesh's picture

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 !