Further to the useful answer by Lernkurve, I conclude that ‘Paste Special…’ does not do the job, while mapping keystrokes to macros created from the ‘paste mode’ dialogue does. Since his first two options apply Word 2013 and up, anyone stuck on 2007 will have to create and map macros.
To record macros, you need the Developers tab enabled in the ribbon, in Word Options/Popular Options.
Macros for the Paste Modes
The macros needed to do the job, recorded by entering the choice menu after pasting are:
' Paste with option ‘original formatting’
' Paste with option ‘match destination’
' Paste with option ‘only text’
I mapped these to Ctrl+Alt+Shift+(<|||>) for keep format, text only and merge format respectively. I chose the modifier keys Ctrl+Alt+Shift to avoid clashes with predefined mappings, while (<|||>) suggested to me looking back (to the source format), neutral and looking forward (to the destination format), even if those are not really what happens.
Meaning of the Options
The meaning of the options is described as follows on MSDN (I have not tested this thoroughly):
- Keep source formatting (
wdFormatOriginalFormatting): “Preserves original formatting of the pasted material” – I presume this includes styles, but wonder what happens if style names clash. I presume that all current formatting is ignored.
- Merge formatting (
wdFormatSurroundingFormattingWithEmphasis): “Matches the formatting of the pasted text to the formatting of surrounding text” – I believe this means that the characters from the source and any emphasis (bold, italic, _ underlining _) are inserted in the current formatting, while all other original formatting is ignored.
- Keep Text only (
wdFormatPlainText): “Pastes as plain, unformatted text.” – Only the characters from the source are inserted, in the current formatting.
Options in Paste Special
I investigated the options in Paste Special…, recording macros for each option, as in the screenshot of the dialogue in Lernkurve’s answer. Some of them seemed to behave as keep format (sometimes doing odd extra things), others as text only, but none as merge format. (To get all options I had to paste text with some extra formatting, otherwise I just got two options; my set of options included “Picture (Windows Metafile)”, not in his screenshot.)
These were the results:
Sub SpecialPasteDoc() ' MS Office Word-document object
Selection.PasteSpecial Link:=False, DataType:=wdPasteOLEObject, Placement _
Sub SpecialPasteRTF() ' Formatted text (RTF)
Sub SpecialPastePlain() ' Unformatted text
Sub SpecialPastePic() ' Picture (Windows Metafile)
Sub SpecialPastePicEnhanced() ' Picture (Enhanced Metafile)
Sub SpecialPasteHTML() 'HTML Format
Selection.PasteSpecial Link:=False, DataType:=wdPasteHTML, Placement:= _
Sub SpecialPasteUnicodeText() ' Unformatted Unicode Text
Selection.PasteSpecial Link:=False, DataType:=20, Placement:=wdInLine, _