A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Macro to open stationery



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old October 3rd 07, 11:26 PM posted to microsoft.public.outlook.program_vba
Clang
external usenet poster
 
Posts: 7
Default Macro to open stationery

Using Outlook 2003

Is it possible to create a macro that will open a different stationery than
the default?
  #2  
Old October 4th 07, 12:17 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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?

  #3  
Old October 4th 07, 08:28 PM posted to microsoft.public.outlook.program_vba
Clang
external usenet poster
 
Posts: 7
Default 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?


  #4  
Old October 4th 07, 09:03 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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?


  #5  
Old October 4th 07, 11:56 PM posted to microsoft.public.outlook.program_vba
Clang
external usenet poster
 
Posts: 7
Default 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?


  #6  
Old October 5th 07, 12:17 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default 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?


 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Need a macro to open a form Kathy Outlook - Using Forms 2 January 24th 07 04:24 PM
VBA Macro to Open Form LDMueller Outlook and VBA 2 December 19th 06 06:54 PM
Can't open Macro, Security or Visual Basic Editor Dao Nguyen Outlook and VBA 2 September 27th 06 03:48 AM
Open Form from Macro [email protected] Outlook - Using Forms 5 June 16th 06 11:42 PM
Cannot open Macro Editor antonio Outlook and VBA 2 May 10th 06 07:48 PM


All times are GMT +1. The time now is 08:01 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-2025 Outlook Banter.
The comments are property of their posters.