excel to email problem

i am able to send emails of worksheets through outlook. what code do i use to open up the actual outlook message window with the attached file rather than just sending it through. i want to be able to type what ever i want in the message body and not have it based on whats in the vba code.

this code does what i want it to do. could anyone help me on how to change to attaching a worksheet instead of the entire book? also would like to have the attachment name be what the file tab name is

Please Login or Register  to view this content.