Log in

View Full Version : VBA Outlook rule autoenable after using out of office autoreply



Skiff
01-30-2017, 09:36 AM
Hi, is it possible to enable rule form "Rules and Alerts" automatically when user enables out of office autoreply (and vice versa)?
Right now I'm just looking for answer but there is no macro recorder in outlook so if it is possible what would be VBA code. I generally manage VBA in Word and Excel, but lack of macro recorder in outlook just leave me clules.

BTW could you point me out to some good Outlook VBA tutorial/database?

Regards
Skiff

skatonni
01-30-2017, 02:32 PM
An Application event for Out of Office appears appropriate, if it existed. https://msdn.microsoft.com/en-us/library/office/ff866895.aspx

You could check the Out Of Office status https://social.msdn.microsoft.com/Forums/office/en-US/64ab56a0-005f-4ae7-845e-b7b476b9b11d/can-setting-the-out-of-office-message-from-vba-be-this-simple?forum=outlookdev in the Startup and Quit events. Once known try to set Rules on or off.

No idea if it is possible.