send to mail recipient

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
 
R

Rick B

Outstanding!!! This was exactly what I was looking for.

Thank you very much

-rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top