Skip to main content

See also:

Create macro and button for paste unformatted text in Outlook 2007

Copy & paste macro code
Copy & paste macro code
Beth McIntire

If you use Paste Special, Unformatted Text frequently in Outlook 2007, you may have noticed that there's no button for this command by itself. Plus, Outlook won't let you record a macro, and copying macro code from Word 2007 doesn't work.

You may want to paste unformatted text if, for example, you're copying and pasting from programs outside of Outlook, such as a Web page or PDF.

Here's how to create a Paste Special, Unformatted Text macro and button to save mouse clicks when using this popular command.

If this article helps you or if you have further suggestions, please feel free to comment below.

If you enjoy my writing, please consider subscribing to my articles by email or following me on Twitter @RaleighTech.

Create macro
Create macro Beth McIntire

Create macro

Click New to bring up a blank, new message in Outlook 2007.

Click the Developer tab along the top. If you do not see Developer along the top, click the Windows orb at the top left. Then, select Editor Options, tick the box next to 'Show Developer Tab in the Ribbon' and click OK.

After selecting the Developer tab, click Macros, then type PasteUnformatted under Macro Name, and click Create.

Copy & paste macro code
Copy & paste macro code Beth McIntire

Copy & paste macro code

This will bring up a Visual Basic window. In the blank space between Sub PasteUnformatted () and EndSub, copy and paste the following text.

Dim objDoc As Word.Document
Dim objSel As Word.Selection

On Error Resume Next

Set objDoc = Application.ActiveInspector.WordEditor
Set objSel = objDoc.Windows(1).Selection

objSel.PasteSpecial Link:=False, _
DataType:=wdPasteText, _
Placement:=wdInLine, _
DisplayAsIcon:=False

Finish and test the macro
Finish and test the macro Beth McIntire

Finish and test the macro

Next, still in the macro programming window, click Tools, References.

Find 'Microsoft Word 12.0 Object Library' in the list (they're in alphabetical order) and click the box next to it to select it, then select OK.

Click the X in the upper right corner to exit the VB macro programming window.

To test the macro, copy some text to the Clipboard, then go back into your blank message and click Developer, Macros, Run.

Create the button
Create the button Beth McIntire

Create the button

To create a shortcut button at the top for your new macro, click the down arrow at the end of the row of icons at the top left of your screen (still in that new Outlook message).

Select More Commands.

Under the 'Choose Commands From' drop-down list, select Macros.

Select PasteUnformatted and click Add.

Over on the right, you can select your new button and click Modify if you'd like to change the mouseover text and/or the displayed icon.