Copy Range of Data from Excel into Outlook Email

[Vlade777]

Hey guys,

This is my first post here, and I'm pretty new to using VBA in Excel. So apologies if this question has been discussed elsewhere, (didn't see it on the main page).

I have an excel document I use to send project updates, however, I have to manually copy/paste the data from Excel into an Outlook mail in order to send it. I'm looking for a Macro that can do 2 things for me.

1 - Open up a new email window and copy/past a range of cells from Excel into the body of said email.
2 - Attach the excel document to the email.

Thanks for anyone who can help

[AlphaFrog]

This link should have the solution you're looking for...


Ron de Bruin
Excel Automation
Mail from Excel with Outlook (Windows)

[Vlade777]

Awesome! Thanks Alpha. I'll check it out today.