If you are using Send in the Excel file menu, just do it with the macro
recorder on, it should give you what you want.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Globe Director" wrote in message
...
I would like to create a VBA macro to e-mail a worksheet. Has anyone
created
this and is willing to share?