Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Macro to open stationery (http://www.outlookbanter.com/outlook-vba/58201-macro-open-stationery.html)

Clang October 3rd 07 11:26 PM

Macro to open stationery
 
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?

Sue Mosher [MVP-Outlook] October 4th 07 12:17 AM

Macro to open stationery
 
Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?


Clang October 4th 07 08:28 PM

Macro to open stationery
 
Sue, thanks for the reply.

I have looked at Eric's solution but it isn't quite what I am looking for.
I would like a macro that will open a new message with a different stationery
other than the default.


"Sue Mosher [MVP-Outlook]" wrote:

Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?



Sue Mosher [MVP-Outlook] October 4th 07 09:03 PM

Macro to open stationery
 
That's exactly what his ApplyStationeryFormatting procedure does -- applies a particular stationery to a message. In his application, the user chooses the stationery from a list, but you could certainly modify his procedure to pass the stationery name as a parameter.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...

I have looked at Eric's solution but it isn't quite what I am looking for.
I would like a macro that will open a new message with a different stationery
other than the default.


"Sue Mosher [MVP-Outlook]" wrote:

Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?



Clang October 4th 07 11:56 PM

Macro to open stationery
 
Sue,

OK I finally got it to work but now I do not have a choice of when I want to
use the special stationery I selected. When I select the "New" message
button it brings up the new stationery. I would like the "New" button to
work as it originally did and want to add an additional button for when I
want to use the special stationery.

Is this possible.


"Sue Mosher [MVP-Outlook]" wrote:

That's exactly what his ApplyStationeryFormatting procedure does -- applies a particular stationery to a message. In his application, the user chooses the stationery from a list, but you could certainly modify his procedure to pass the stationery name as a parameter.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...

I have looked at Eric's solution but it isn't quite what I am looking for.
I would like a macro that will open a new message with a different stationery
other than the default.


"Sue Mosher [MVP-Outlook]" wrote:

Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?



Sue Mosher [MVP-Outlook] October 5th 07 12:17 AM

Macro to open stationery
 
What is your stationery setting in Tools | Options | Mail Format?

It would help if you provided complete details of how you adapted Eric's technique to your specific scenario. You should have written a macro to create a new message and then apply stationery to it using his procedure. Is that what you did?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...
Sue,

OK I finally got it to work but now I do not have a choice of when I want to
use the special stationery I selected. When I select the "New" message
button it brings up the new stationery. I would like the "New" button to
work as it originally did and want to add an additional button for when I
want to use the special stationery.

Is this possible.


"Sue Mosher [MVP-Outlook]" wrote:

That's exactly what his ApplyStationeryFormatting procedure does -- applies a particular stationery to a message. In his application, the user chooses the stationery from a list, but you could certainly modify his procedure to pass the stationery name as a parameter.

"Clang" wrote in message ...

I have looked at Eric's solution but it isn't quite what I am looking for.
I would like a macro that will open a new message with a different stationery
other than the default.


"Sue Mosher [MVP-Outlook]" wrote:

Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?



Clang October 5th 07 06:09 PM

Macro to open stationery
 
Oops, sorry I still had my station selected in Tools|Options|Mail Format. If
I change this back to none or blank then the macro does not work.

It first indicates "You must initiate a reply to an e-mail before you can
apply stationery formatting" (I want to be able to use it for a new message)
and if I do try it with a replay I do not find my stationery in the list.

"Sue Mosher [MVP-Outlook]" wrote:

What is your stationery setting in Tools | Options | Mail Format?

It would help if you provided complete details of how you adapted Eric's technique to your specific scenario. You should have written a macro to create a new message and then apply stationery to it using his procedure. Is that what you did?

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...
Sue,

OK I finally got it to work but now I do not have a choice of when I want to
use the special stationery I selected. When I select the "New" message
button it brings up the new stationery. I would like the "New" button to
work as it originally did and want to add an additional button for when I
want to use the special stationery.

Is this possible.


"Sue Mosher [MVP-Outlook]" wrote:

That's exactly what his ApplyStationeryFormatting procedure does -- applies a particular stationery to a message. In his application, the user chooses the stationery from a list, but you could certainly modify his procedure to pass the stationery name as a parameter.

"Clang" wrote in message ...

I have looked at Eric's solution but it isn't quite what I am looking for.
I would like a macro that will open a new message with a different stationery
other than the default.


"Sue Mosher [MVP-Outlook]" wrote:

Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?




Sue Mosher [MVP-Outlook] October 5th 07 07:29 PM

Macro to open stationery
 
Eric's full application works with replies, by design. To make it work with new messages, you would need to adapt it along the lines I indicated earlier.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Clang" wrote in message ...
Oops, sorry I still had my station selected in Tools|Options|Mail Format. If
I change this back to none or blank then the macro does not work.

It first indicates "You must initiate a reply to an e-mail before you can
apply stationery formatting" (I want to be able to use it for a new message)
and if I do try it with a replay I do not find my stationery in the list.

"Sue Mosher [MVP-Outlook]" wrote:

What is your stationery setting in Tools | Options | Mail Format?

It would help if you provided complete details of how you adapted Eric's technique to your specific scenario. You should have written a macro to create a new message and then apply stationery to it using his procedure. Is that what you did?



"Clang" wrote in message ...
Sue,

OK I finally got it to work but now I do not have a choice of when I want to
use the special stationery I selected. When I select the "New" message
button it brings up the new stationery. I would like the "New" button to
work as it originally did and want to add an additional button for when I
want to use the special stationery.

Is this possible.


"Sue Mosher [MVP-Outlook]" wrote:

That's exactly what his ApplyStationeryFormatting procedure does -- applies a particular stationery to a message. In his application, the user chooses the stationery from a list, but you could certainly modify his procedure to pass the stationery name as a parameter.

"Clang" wrote in message ...

I have looked at Eric's solution but it isn't quite what I am looking for.
I would like a macro that will open a new message with a different stationery
other than the default.


"Sue Mosher [MVP-Outlook]" wrote:

Eric's approach at http://blogs.officezealot.com/legaul...7/21/7581.aspx might be what you're looking for.

"Clang" wrote in message ...
Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?





All times are GMT +1. The time now is 07:58 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