With Excel 2013 ? we use the Share Function.
- File | Share
- Select Email Option | Send as Attachment
- File | Save & Send
- Send Using Email
With Excel 2007 whole workbook as attachment, as PDF file, as XPS file or Internet Fax via your Outlook.
- Office Button | Send
- Select your Option for sending format
Once your Outlook message appears it can be used as a normal email message but your Excel file has already been attached for you without the time wasted browsing for your file to attach.
All you need to do is add the details you need to and click Send. Is that easy or what?
If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel Tips.