Excel Macro To Create A New Email With A Range of Cells Included in the body

[RickN85]

Hi Guys.. Fairly new to this.. It's been a while since I last did any kind of vba but I've managed to scramble together some code which creates an email, adds a subject title, gets an email from one of the cells for the person who its going to, adds text to the body of the email and copies a range of cells sticks them into a new excel file and adds this as an attachment to the email. However instead of the range of cells been added as an attachment I'd like to just add that range of cells into the body of the email along with a set template.

I'm using MS Office 2003 (MS Office Outlook & Excel 2003) to try and send the emails

Please Login or Register  to view this content.

Any help would be greatly appreciated

[RickN85]

Spreadsheet_Image.jpg

Here's an image of the sheet i'm working with as well