Emailing Unsaved Spreadsheet

[Nick_law]

I am looking to email an open, un-saved spreadsheet with automated email address, Subject and Body of the email.

I have been able to attach the spreadsheet to an email without saving it first. I have also been able to add the email address, subject, body of the email and a saved Excel file.

Is it possible to send an email with an un-saved spreadsheet with the email address and subject and Body?

I am using Outlook 11.

Thanks!
Nick

[Bob Phillips]

Can't you just save it before emailing?

[Nick_law]

I just wanted to know if it is possible to do it. I could save it, but I'd rather not if i can help it.

[Bob Phillips]

The only other way I can think of is sending it as a range, effectively pasting it from the sheet to the email.