G
Guest
What is the code for paste special in Outlook, I know it for Word and Excel,
but not Outlook.
but not Outlook.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Michael Bauer
Hi,
what is "paste special"? If there´s a button on a Menubar for that than
you can automate that button. Please see
http://www.outlookcode.com/d/tips/commandbarfun.htm for a sample.
what is "paste special"? If there´s a button on a Menubar for that than
you can automate that button. Please see
http://www.outlookcode.com/d/tips/commandbarfun.htm for a sample.
G
Guest
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?
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?
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?
G
Guest
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.
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
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.