I need to write a program to send emails from my excel.
The emails should come out every thursday evening.
And the program should pick up email id from the excel sheet.
Looking at the previous posts on this site, I will be able to write a program to do that. But I am not sure how to make the program to run automatically every thursday evening(or at any given time).
Any help would be greatly appreciated
Automatic emails from Excel
-
Re: Automatic emails from Excel
well rather than use the OnTime method I would suggest you do the following:
1. Create a Workbook_Open event that calls your email routine.
2. Ensure your Macro Security Level is set to Low (if you wish this to run without user prompt being required)
3. Create an Event in the Windows Scheduler to launch your XL file at the required time.When the file is launched the open event will be executed which will in turn call your mailing routine.
-
Re: Automatic emails from Excel
Quote from lasw10well rather than use the OnTime method I would suggest you do the following:
1. Create a Workbook_Open event that calls your email routine.
2. Ensure your Macro Security Level is set to Low (if you wish this to run without user prompt being required)
3. Create an Event in the Windows Scheduler to launch your XL file at the required time.When the file is launched the open event will be executed which will in turn call your mailing routine.
Good advice all except for number 2. My advice is this never, never, never, never, ever do this. You will someday forget that you've done this and somewhere some how you'll get a virus and it'll have free reign.
Good news though there is an alternative. But first. I have 3 pcs at work 2 of which act as mini servers and they do exactly what you want to do, although they do it 3 times an hour 24 hours a day, and their security is set to HIGH.
Check out the information that I posted in this thread for information
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!