Assigning an Outlook template to a toolbar

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Heather Pitch - 30 Jun 2006 22:02 GMT

What VBA script do I use in my macros to assign a .oft file to a toolbar
button?

Thanks.

Reply to this Message

Sue Mosher [MVP-Outlook] - 30 Jun 2006 22:25 GMT

You can use Application.CreateItemFromTemplate.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> What VBA script do I use in my macros to assign a .oft file to a toolbar
> button?
>
> Thanks.

Reply to this Message

Heather Pitch - 30 Jun 2006 22:43 GMT

Thanks for your speedy reply Sue. I am a relative novice at VBA scripting.
Are you able to help me with the whole script?

> You can use Application.CreateItemFromTemplate.
>
> > What VBA script do I use in my macros to assign a .oft file to a toolbar
> > button?
> >
> > Thanks.

Reply to this Message

Sue Mosher [MVP-Outlook] - 30 Jun 2006 23:01 GMT

Then it's time you learned about the Object Browser: Press ALt+F11 to open the VBA environment in Outlook, then press F2. Switch from <All Libraries> to Outlook to browse all Outlook objects and their properties, methods, and events. Select any object or member, then press F1 to see its Help topic, usually including sample code.

Note that VBA, like VBScript, has an intrinsic Application object, so you don't need this statement:

Set myOlApp = CreateObject("Outlook.Application")

You can use this instead:

Set myOlApp = Application

Signature

> Thanks for your speedy reply Sue. I am a relative novice at VBA scripting.
> Are you able to help me with the whole script?
[quoted text clipped - 5 lines]
>> >
>> > Thanks.

Reply to this Message