What would an Outlook 2007 macro to automate Paste Special - Unformatted Text look like?

Posted by Gary Petersen on Super User See other posts from Super User or by Gary Petersen
Published on 2009-08-18T23:59:24Z Indexed on 2010/03/31 19:13 UTC
Read the original article Hit count: 409

Filed under:

outlook

|

outlook-2007

|

vba

I'd like to assign a macro in Outlook 2007 to a Toolbar button that would execute the equivalent of these clicks when there is formatted text in the Windows clipboard:

Click the Paste icon by the bottom arrow
Click the Paste Special link.
Click the Unformatted Text link.

I have similar macros in Excel 2007 and Word 2007 but haven't been able to get one to work in Outlook 2007 / VBA. What would the VBA code for such a macro be?

© Super User or respective owner

Related posts about outlook

Outlook 2007 - Cannot start Outlook - Cannot open the Outlook window

as seen on Super User - Search for 'Super User'
I went to open Outlook 2007 on my Windows 7 32bit machine and it came up with this error: Cannot start Microsoft Office Outlook. Cannot open the Outlook window. The set of folders cannot be opened. The information store could not be opened. I have deleted and created a new profile in Control Panel… >>> More
How To Switch Back to Outlook 2007 After the 2010 Beta Ends

as seen on How to geek - Search for 'How to geek'
Are you switching back to Outlook 2007 after trying out Office 2010 beta? Here’s how you can restore your Outlook data and keep everything working fine after the switch. Whenever you install a newer version of Outlook, it will convert your profile and data files to the latest format. … >>> More
Outlook 2007 Backup to D:\Outlook Fails - Access Denied, Write-Protected or File In Use

as seen on Super User - Search for 'Super User'
I can successfully save the Outlook PST file to the default location on the C drive (C:\Documents and Settings\user\ ... \Outlook) but when I change the backup save to directory to Outlook on the D drive I get the error: Cannot copy Outlook: Access is denied. Make sure the disk is not full or write… >>> More
Communication between Outlook addin and Program Automating Outlook

as seen on Stack Overflow - Search for 'Stack Overflow'
I have an application that uses the automation interfaces to Microsoft Outlook to create a mail message and then after it is sent save an archive of that email message in my application. I am hitting issues with a number of the third party encryption addins because by the time the Sent event fires… >>> More
prevent outlook stationery from showing up in my email (Outlook 2007)

as seen on Stack Overflow - Search for 'Stack Overflow'
There are some people in my office who insist on using cute stationery and some of it makes messages difficult to read. I really just want to read email on a white background with no distractions. Is there a way to disable stationery on incoming mail in Outlook? (Without switching to "plain text… >>> More

Related posts about outlook-2007

Outlook 2007 unable to connect to exchange server

as seen on Server Fault - Search for 'Server Fault'
I came into the office a week ago and outlook has refused to connect ever since, it just says "Disconnected" in the bottom right-hand corner. I've tried restarting it, rebooting Windows etc. I'm the only one if our office who is having this problem, so it's not a general problem with the server.… >>> More
Outlook 2007 unable to connect to exchange server

as seen on Super User - Search for 'Super User'
I came into the office a week ago and outlook has refused to connect ever since, it just says "Disconnected" in the bottom right-hand corner. I've tried restarting it, rebooting Windows etc. I'm the only one if our office who is having this problem, so it's not a general problem with the server.… >>> More
Outlook 2007 Backup to D:\Outlook Fails - Access Denied, Write-Protected or File In Use

as seen on Super User - Search for 'Super User'
I can successfully save the Outlook PST file to the default location on the C drive (C:\Documents and Settings\user\ ... \Outlook) but when I change the backup save to directory to Outlook on the D drive I get the error: Cannot copy Outlook: Access is denied. Make sure the disk is not full or write… >>> More
Outlook 2007 freezes my system when I start it says it is "synchonizing folders"

as seen on Super User - Search for 'Super User'
When I try to start Outlook 2007, my system freezes, and Outlook says it is "synchonizing folders". I don't use exchange, and haven't seen any answers online. I've tried turning off the exchange integration (right clicking my folders) Since doing the latter, there is no longer an icon in the system… >>> More
why is Outlook 2007 continuously losing Connection to Exchange Server

as seen on Server Fault - Search for 'Server Fault'
what could be the reason for Outlook 2007 continously losing and reestablishing the connection to exchange? I tried disabling all anti-viruses and firewalls but it did not help. I should mention that even though this seems to happen to all users, some users cannot even send emails because it happens… >>> More