Format painter macro for outlook

matt_m
matt_m used Ask the Experts™
on
Hi Experts,

I am hoping somoene could supply some VBA code for Outlook 2003 that  would do the same thing as the format painter in excel.  Ultimately I want this macro assigned to a button so I can use it regularly.  

Thanks!
Matt
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Thanks for your quick reply!

I have seen this answer elsewhere before, however I don't want to use word as my email editor hence I wanted to see if it could be done via a macro.

Top Expert 2010

Commented:
Hi, matt_m.

I might be able to help, but I'm not a heavy Excel user and don't know what the format painter does.  Can you explain what it is you want this macro to do?
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Author

Commented:
In excel it copies the format settings from a cell(s) and pastes those settings onto other cells.  In outlook it would be just on text.
Top Expert 2010

Commented:
Not possible in any practical manner.  

Author

Commented:
Conceptually its pretty straightforward - all it is

1. Copy selected text
2.  Past special (formats only)
Top Expert 2010

Commented:
I agree that it's conceptually simple.  That doesn't change anything though.  Outlook 2003 doesn't expose the ability to determine the text selected or its format.  It doesn't have a paste special format only option either.  Word may, but you've already indicated that you don't want to use Word.  

Author

Commented:
even using VBA?  I find that hard to believe!
Top Expert 2010
Commented:
Why do you find it hard to believe?  The Outlook object model doesn't expose everything, especially in 2003 and earlier.  There's a long list of things that aren't exposed in 2003 and earlier.  Outlook 2007 exposes more, but there are still things that cannot be done via programming because Microsoft has not made them available through Outlook's object model.

In 2003 the editor object is only available if Outlook is set to use Word as its editor.  The following quote is taken directly from Microsoft's online help: "The WordEditor property is only valid if IsWordMail returns True and the EditorType is olEditorWord."  Microsoft fixed that in Outlook 2007 which only uses Word as its editor.  There may be 3rd-party tools that expose the Outlook editor in 2003, but the capability is not built in.  

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial