VBA for R Click > Keep Text Only in Outlook


Is there a way to "Record" a macro in Outlook (2010) as is possible in Excel & Word?

Since I don't know VBA, I've always used the Macro Recorder in Excel & Word but apparently Outlook does not include a Macro Recorder, or at least I can't find one.

The macro I'm after is for pasting content-only from the clipboard. Doing it with the mouse requires two steps (R Click > Keep Text Only).

2015-07-18b-EE.PNGCould someone post the VBA code for doing that?

By the way, a similar function is present as "Paste Value" in Excel and "Paste and Keep Text Only" in Word and each has a built-in icon which can be added to the Quick Access Toolbar (QAT). However, the closest shortcut I can find for the Outlook QAT is one called "Paste" but it requires two clicks, hence my request for the code.

I just got some awesome EE instructions in an associated thread re how to create a shortcut icon and add it to the QAT once the macro is in place, however I obviously need to create the macro first.

By the way, here is a screenshot of where I assume the code should be posted once I have it:

2015-07-18c-EE.PNGIs that the right location?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Joe Winograd, Fellow&MVEDeveloperCommented:
Hi Steve,

As I mentioned at your other question, Outlook does not have a Macro Recorder — you have to write VBA code. Put this one line of code in your PasteContent macro (yes, that is the right location — between the "Sub" and the "End Sub"):

SendKeys ("%^(v)u~")

It will do what you want, although using a different technique — Alt-Ctrl-V then U and Enter (right-click is trickier, whereas this use of SendKeys is straightforward and achieves the same objective). Also, you must add your new PasteContent icon to the QAT in the Compose window, since the Main window and Compose window have separate QATs — and, of course, you'll need to click your PasteContent icon in the Compose window. Regards, Joe

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Alexei KuznetsovMicrosoft Outlook MVPCommented:
Don't you want to just go to File -> Options -> Mail -> Editor Options -> Advanced and change the "Cut, copy and paste" settings there? You can just set "Keep Text Only" as default formatting for your emails.
Martin LissOlder than dirtCommented:
I've requested that this question be closed as follows:

Accepted answer: 250 points for Joe Winograd's comment #a40888125
Assisted answer: 250 points for Alexei Kuznetsov's comment #a40888442

for the following reason:

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
WeThotUWasAToadAuthor Commented:
Thanks for the replies. My apologies for getting back to this thread.
Joe Winograd, Fellow&MVEDeveloperCommented:
You're welcome, Steve. No problems on the delay getting back. Hope all is well in your world. Regards, Joe
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.