Hello,
I would like to send an e-Mail message to my team every day at 12:00 A.M.
I can't find it in the options, how would I VBA code this?
Hello,
I would like to send an e-Mail message to my team every day at 12:00 A.M.
I can't find it in the options, how would I VBA code this?
Hi,
One way - by running the eMail macro below. You might prefer to put it in the workbook open event so that it runs automatically
Note, this requires MS Outlook as the email client. For a generic (software independent SMTP version) then post again.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Richard Buttrey; 04-09-2014 at 01:33 PM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Workbook Open? I won't be using this in Excel.
Would this work in Outlook VBA?
Sorry, I hadn't spotted it was in the Outlook forum.
The code as written won't work in Outlook, only Excel. I'm not familiar with VBA for Outlook so can't comment further although no doubt there will be some equivalent functionality.
Well, thanks for trying!
FYI - the SendEmail Sub works to create the message.
So I only need the command to have it send automatically at the determined time.
I found this on another forum:
I know this post is old, but I thought I'd answer anyway. Outlook does not have an OnTime method, but Excel does. That is why it works in Excel but not Outlook.
To simulate the OnTime Method, create a task with a reminder for the time you want the macro to run. Use a unique Subject string for the task. Hook the BeforeReminderShow Event and check for the unique string in the Subject that you specified when you created the task. If it's a match, run the macro you wanted to run at that time. Also, set Cancel = True so the reminder doesn't actually fire (it already did it's job so it doesn't need to actually fire).
__________________
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks