Back to Blog
Office 365 for mac autoreply7/13/2023 ![]() You could choose the option Notification for all macros, then accept it each time you restart Outlook, however, because it's somewhat hard to sneak macros into Outlook (unlike in Word and Excel), allowing all macros is safe, especially during the testing phase. The macros will not work with the top two options that disable all macros or unsigned macros. OOFAssistant.OutOfOfficeTextExternal = "I am out of the office currently and will return on " & Format(OOFAssistant.EndTime, "dddd, MMMM d, yyyy at h:mm AM/PM") & "." & _įirst: You need to have macro security set to the lowest setting, Enable all macros during testing. OOFAssistant.OutOfOfficeTextInternal = "I am out of the office currently and will return on " & Format(OOFAssistant.EndTime, "dddd, MMMM d, yyyy at h:mm AM/PM") & "." & _ OOFAssistant.EndTime = sEnd + #9:00:00 AM# OOFAssistant.StartTime = sStart + #4:00:00 PM# Run it manually each day or use a reminder to trigger it.Ĭase Sunday, "Monday", "Tuesday", "Wednesday", "Thursday" If it's Friday, the out of office ends in 3 days. If it's a weekday, the out of office is set to end the next morning. Use rdoOofAudienceAll (value: 2) to send replies to all senders rdoOofAudienceKnown (value: 1) to send only to known senders rdoOofAudienceNone (value: 0) disables external replies.ĭifferent OOF Weekdays and WeekendsThis version of the macro checks the days of the week. rdoOofDisabled = 0 rdoOofEnabled = 1 rdoOofScheduled = 2 For a complete explanation of all properties, see RDOOutOfOfficeAssistant object, PropertyĮnable, disable, or schedule the automatic reply. The table below lists the possible values for two properties, State and ExternalAudience. OOFAssistant.EndTime = sEnd + #8:45:00 AM# OOFAssistant.StartTime = sStart + #4:55:00 PM# SEnd = InputBox("End date for OOF.", "OOF dates", Date + 1) To use this macro to enable automatic replies every day before you leave the office, change these lines. OOFAssistant.OutOfOfficeTextExternal = "I am out of the office currently and will return on " & Format(OOFAssistant.EndTime, "dddd, MMMM dd, yyyy at hh:mm AM/PM") & "." & _ OOFAssistant.OutOfOfficeTextInternal = "I am out of the office currently and will return on " & Format(OOFAssistant.EndTime, "dddd, MMMM dd, yyyy at hh:mm AM/PM") & "." & _ OOFAssistant.ExternalAudience = 2 '2 = All 1 = Contacts only OOFAssistant.EndTime = sEnd + #10:00:00 AM# OOFAssistant.StartTime = sStart + #3:00:00 PM# Set OOFAssistant = Store.OutOfOfficeAssistant ' Skip accounts as they don't have internal and external OOF options. If (Store.StoreKind = skPrimaryExchangeMailbox) Then SEnd = InputBox("End date for OOF.", "OOF dates", Date + 3) SStart = InputBox("Start date for OOF.", "OOF dates", Date) Set rdo = CreateObject("Redemption.RDOSession") You'll also need to install Redemption Developer version. To use this macro, add it to the Quick Access toolbar or ribbon or use a reminder to trigger it. As written, it skips accounts because they do not support automatic replies to internal addresses. The macro will enable and configure automatic replies in all business Exchange accounts in your profile. (I like to enable automatic replies early, so people who email right before I leave the office know I'm out.) You can enter the date in any valid format, such as "1/17" (Outlook will add the year). This macro sample asks for the start and end dates and uses a predefined start and end times. If you want to use a macro to enable automatic replies in newer versions of Outlook, you need to use Redemption's RDOOutOfOfficeAssistant object to update Automatic Replies using a macro.Ī macro makes it a lot easier to set up automatic replies if you have more than one Exchange account and want to set the same out of office message on each account. As of Outlook 2010, Outlook does not use CDO. You can find a lot of older macros on the internet that can turn Out-of-Office off and on but they only work in Outlook 2007 and older as they use CDO. ![]() What you really need is a macro to turn automatic replies on and set the times for you. Plus, Outlook is really good about popping up a banner reminding you that Automatic replies are on. Every morning when you come in, you can turn it off and reset it to come back on after 5 pm. You need to set it up each time (you can't say 'every day from 5 pm until 8 am tomorrow'), but you can schedule it ahead of time.
0 Comments
Read More
Leave a Reply. |