Re: emailing range of cells/or full worksheet?

i was wondering if it is possible to add an oleobject(the excel
worksheet) to an email so that it is visible in the body of the email.
Here's my problem.
the users that will be receiving this email don't have excel, and i need
to have the data that is sent to them look identical to what is in my
excel spreadsheet, so the original code that we tried doesnt work. i
need for excel to control outlook so it will basically goto the insert
menu, object, create object from file, and display the excel worksheet
in the email. i tried this manually without code and they are able to
see the excel worksheet this way.
or possibly display the excel worksheet as an .rtf with a table as my
spreadsheet?
Thanks for all of your help,
Josh
let me know if i need to clarify anything further.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If your users don't have Excel, I'd recommend that you construct an HTML format message with the Excel data arranged in a table.

The newsgroup interface at Developersdex (http://www.developersdex.com) does not automatically quote the text of the original message when you post a reply. Please take the time to quote the original message manually so that people reading your current response can understand what you're talking about. Otherwise, you may not receive the answer you're looking for.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"josh ashcraft" <joshashcraft@yahoo.com> wrote in message news:uCpVsGgfDHA.2408@TK2MSFTNGP09.phx.gbl...
> i was wondering if it is possible to add an oleobject(the excel
> worksheet) to an email so that it is visible in the body of the email.
> Here's my problem.
> the users that will be receiving this email don't have excel, and i need
> to have the data that is sent to them look identical to what is in my
> excel spreadsheet, so the original code that we tried doesnt work. i
> need for excel to control outlook so it will basically goto the insert
> menu, object, create object from file, and display the excel worksheet
> in the email. i tried this manually without code and they are able to
> see the excel worksheet this way.
> or possibly display the excel worksheet as an .rtf with a table as my
> spreadsheet?
> Thanks for all of your help,
> Josh
> let me know if i need to clarify anything further.
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!