Solved

Outlook macro: show To-Do Bar

Posted on 2009-05-18
3
813 Views
Last Modified: 2012-08-13
Hi,
i need a VBA Macro script to show the Outlook 2007 To-Do Bar on startup of Outlook, but i don't know how to do this.
Could u help me pls?

regards
mesX
0
Comment
Question by:mesX
  • 2
3 Comments
 
LVL 11

Accepted Solution

by:
Antagony1960 earned 250 total points
ID: 24413515
1. Open the VBA window (Alt+F11).
2. In the Project Explorer (press Ctrl+R if you don't see it) drill down to "Project...|Microsoft Office Outlook Object|ThisOutlookSession"
3. Right-click ThisOutlookSesion and select "View Code" from the context menu.
4. Paste in the attached code.
5. Save your work and close VBA

Now, whenever Outlook is started up it should open the To Do Bar.
Private Sub Application_Startup()
Dim myOlExp As Outlook.Explorer
    Set myOlExp = Application.ActiveExplorer
    myOlExp.ShowPane olToDoBar, True
    Set myOlExp = Nothing
End Sub

Open in new window

0
 

Author Closing Comment

by:mesX
ID: 31582533
Works perfect! Thx!
0
 
LVL 11

Expert Comment

by:Antagony1960
ID: 24413821
Glad to have helped. :-)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you don't know how to downgrade, my instructions below should be helpful.
Read this checklist to learn more about the 15 things you should never include in an email signature.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question