Paste Special is like the Paste command, but special. Meaning it can do more
than just paste, like paste as text, and my fav, without format and it uses
whatever the current format is for where you are pasting the data. Also
saves a lot of headaches that way, because remember, whenever you paste, you
are pasting everything, the format, the font, etc.
Here is the code for Word’s Paste Special:
Selection.PasteSpecial Link:=False, DataType:=wdPasteText
Here is the code for Excel’s Paste Special:
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
What is Outlooks?