![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#6
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook macro abends but Word macro runs successfully | Jreue | Outlook and VBA | 0 | December 14th 06 12:55 AM |
Address prompt | Lawrence J.Ryz | Outlook - Using Contacts | 1 | October 24th 06 01:09 PM |
Call macro stored in Excel workbook from Outlook's macro | Gvaram | Outlook and VBA | 5 | October 4th 06 07:26 AM |
security prompt | Rog | Add-ins for Outlook | 1 | July 13th 06 06:46 AM |
Macro to prompt for metadata and them place in the subject line | Ben Bazian | Outlook and VBA | 1 | April 12th 06 07:19 AM |