send to mail recipient

  • Thread starter Thread starter Rick B
  • Start date Start date
R

Rick B

Is there a way to send a specific worksheet via email within the body of the
email as in File | Send To | Mail Recipient. I can see how to send the whole
workbook as an attachment and also send it as a routing recipient but can
not see how send it to one mail recipient with VBA.

I am using Excel and Outlook version 2002

-rick
 
Back
Top