Link to home
Start Free TrialLog in
Avatar of WeThotUWasAToad
WeThotUWasAToad

asked on

VBA for R Click > Keep Text Only in Outlook

Hello,

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

User generated imageCould 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.

User generated image
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:

User generated imageIs that the right location?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Joe Winograd
Joe Winograd
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Avatar of WeThotUWasAToad
WeThotUWasAToad

ASKER

Thanks for the replies. My apologies for getting back to this thread.
You're welcome, Steve. No problems on the delay getting back. Hope all is well in your world. Regards, Joe