Way to add prompt to this macro?
On Sun, 16 Dec 2007 17:55:15 -0500, "Sue Mosher [MVP-Outlook]"
wrote:
Because I stupidly forgot the text for the MsgBox function's return value:
strMsg = "Do you want to run the macro to expand all the folders... ?"
If MsgBox(strMsg, vbYesNo + vbQuestion, "Expand all?") = vbYes Then
ExpandAllFolders
End If
lol Thank you! Works just perfectly now. Next time a colleague
comes around just as I've opened Outlook, I can press "no" before he
asks me something that requires an email response and we don't need to
wait for the macro to go through g. (That literally happened to me
a couple of weeks ago; freaks people out, this macro does lol. I
should have just chosen disable then re-opened O2K after, but didn't
think of that on the spur of the moment ... g).
Also, what's neat is that I can see the folders and they remain
expanded a few times Outlook opens, so it needs the macro run only
every few launches. Pretty neat O2K behaviour not to need to do it
each time.
|