Send Sheet as an attachment and Use Range as Body

Thank you for the response apo

i've checked that guide out already. I have tweaked some of Mr. Ron de Bruin's code to make it work but i'm at my limit of VBA knowledge.

The code I posted is actually a combination of two of his codes

1. Send a sheet as an email attachment
2. Send email to a distribution list on a reference cell

I'm trying to add inset another feature to the code which is to copy/paste the on cells B10:E10 to the body of the message. I just don't know how to make it work.

Im trying to insert this code but it wont work. the body of the email is still empty.

Please Login or Register  to view this content.

What I want to accomplish is to have the code on my first post to work with this code:
http://www.rondebruin.nl/win/s1/outlook/bmail2.htm

But its too complicated for me with all the function and stuff. I really need help with understanding this one.

Thank you