Outlook Macro

M

Michael_Corral

What is the code for paste special in Outlook, I know it for Word and Excel,
but not Outlook.
 
M

Michael_Corral

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?
 
M

Michael Bauer

Michael,

I think it´s the commandbutton "Insert Contents". There´s no method in
the Outlook object model for this. You could automate a click on that
button but it works only if the mail body has the focus and even then
you don´t know where the cursor is.

Why don´t you use Word?
 
M

Michael_Corral

Outlook Contacts are not associated, I believe, with Word, and the paste
special command is invaluable to me. I also utilize a programmable mouse
that I wanted to set up a Macro that is executable with a short cut key. If
MS ever decides to contact one of the best and experienced office admins, me,
I would express to them the many things that are needed for office
administration, and once again, Paste Special is invaluable to me. So if you
do happen to find out what the code is, it would much obliged, in addition to
programming Macros to have hot keys in Outlook, similar to Word and Excel.
 
M

Michael Bauer

Michael, please try the RTFEditor from Redemption (www.dimastr.com).
Maybe it´s PasteFromClipboard method is doing the job.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook


Michael_Corral said:
Outlook Contacts are not associated, I believe, with Word, and the paste
special command is invaluable to me. I also utilize a programmable mouse
that I wanted to set up a Macro that is executable with a short cut key. If
MS ever decides to contact one of the best and experienced office admins, me,
I would express to them the many things that are needed for office
administration, and once again, Paste Special is invaluable to me. So if you
do happen to find out what the code is, it would much obliged, in addition to
programming Macros to have hot keys in Outlook, similar to Word and Excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top