This is my first post on this forum and my first time working with Excel.
I need help with an email macro to do the following;

The spreadsheet is where customers can order certain goods,
The customer data is contained on Sheet2:B1..H67 - there are also vlookup functions within these cells,
I would like the customer to click a button called "Send Order by Email" and the order (Sheet2:B1..H67) emailed to sales@company.com,
It does not matter whether the order is emailed as an attachment, as data within the email itself or in another format.
The recipient of this email order must simply be able to print the order - directly from Outlook email software or from within Excel.

Your help will be greatly appreciated.