Is it posisble to Copy-Paste into an Outlook 2007 mail message from another Office application such

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

I'm trying to copy a Microsoft Excel range (2002) which includes
(potentially) non-text data too, into an Outlook (2007) mail message. The
only way I've been able to do so far is by finding the Outlook message
window, and sending Ctrl+V keystrokes into the application when in focus....
there's surely a better way... anyone got any suggestions ?


Thanks in advance,


Steve
 
Just a selection - a 2D range, anything more, would simply become an
attachment - which is easy to do programatically.

I'm really just trying to automate what can currently be done within the
GUI... Select range of cells within Excel (that may or may not contain
picture/graphs/ etc...) and paste directly into a new Outlook message...

However it seems that the Outlook Object model does not support the paste
operation for emails, even though the GUI does. Hopefully I've overlooked
something... since even with my clunky 80% of the time solution, I find
that it's not WYSIWYG - AutoShapes that have embedded text simply appear in
the copied/cloned version without the embedded text (even if you do the
copy-paste manually)... sigh.... I'm sure I'm doing something wrong but..
what ?




Diane Poremsky said:
Are you trying to use automation? Do you want to send the entire worksheet
or just a selection?

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
mailto:[email protected]

EMO - a weekly newsletter about Outlook and Exchange:
mailto:[email protected]

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


Steven said:
I'm trying to copy a Microsoft Excel range (2002) which includes
(potentially) non-text data too, into an Outlook (2007) mail message.
The only way I've been able to do so far is by finding the Outlook
message window, and sending Ctrl+V keystrokes into the application when
in focus.... there's surely a better way... anyone got any suggestions ?


Thanks in advance,


Steve
Click to expand...
Click to expand...
 
Back
Top