Code for send to recipient as (Excel)page, instead of attachment?

[Lee]

I understand .Attachment, but what's the code for sending excel as just a page?
Thanks if you know.

 

[Sue Mosher [MVP]]

Office version?

 

[Lee]

Sorry. Office 2000

 

[Sue Mosher [MVP]]

And the issue is? Please keep all the necessary information together in your
posts.

 

[Lee]

In Outlook 2000 VBA, is there a way to get the OL object to send an
Excel page as a page, instead of as an attachment?
I've looked at the Outlook models, but if it's there, I'm sure missing
it.

Thanks again.

Lee Embrey

 

[Sue Mosher [MVP]]

In Office XP and 2003 and later, yes, but not in Office 2000. A workaround
would be to build an HTML table in the message that duplicates the layout of
your Excel table.