Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Assigning an Outlook template to a toolbar (http://www.outlookbanter.com/outlook-vba/19483-assigning-outlook-template-toolbar.html)

Heather Pitch June 30th 06 10:02 PM

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

Thanks.

Sue Mosher [MVP-Outlook] June 30th 06 10:25 PM

Assigning an Outlook template to a toolbar
 
You can use Application.CreateItemFromTemplate.

--
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

"Heather Pitch" Heather wrote in message ...
What VBA script do I use in my macros to assign a .oft file to a toolbar
button?

Thanks.


Heather Pitch June 30th 06 10:43 PM

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

"Sue Mosher [MVP-Outlook]" wrote:

You can use Application.CreateItemFromTemplate.

--
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

"Heather Pitch" Heather wrote in message ...
What VBA script do I use in my macros to assign a .oft file to a toolbar
button?

Thanks.



Sue Mosher [MVP-Outlook] June 30th 06 11:01 PM

Assigning an Outlook template to a toolbar
 
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

--
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

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

"Sue Mosher [MVP-Outlook]" wrote:

You can use Application.CreateItemFromTemplate.

--
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

"Heather Pitch" Heather wrote in message ...
What VBA script do I use in my macros to assign a .oft file to a toolbar
button?

Thanks.




All times are GMT +1. The time now is 12:24 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com