In a workbook with a single sheet, if I use "File, Send to, Mail Recipient" the recipient gets an email larger than 3MB, but if I choose "File, Send to, Mail Recipient (as Attachment)", they get an email less than 1MB.

I prefer the former as the recipient gets a message with the info in the message body, rather than an attachment, but the file size (arriving in Outlook) is becoming and issue. The excel formatting also needs to be retained.

Suggestions?

Many thanks,
Mike