Solved

Outlook macro: show To-Do Bar

Posted on 2009-05-18
3
788 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Find out what you should include to make the best professional email signature for your organization.
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…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now