Send Excel Worksheet using VBA

[chrisaroundtown]

Hi,

I am after a line of code to do the same thing as going to File then Send To Mail Recipient.

Does anyone know how to do this?

Thanks
Chris

 

[Molby]

If your running in Outlook then I believe:

Outlook.Mailitem.Send

Otherwise you will need to set a reference in whatever application you are in.

 

[xlbo]

Try using the macro recorder whilst performing the action

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[chrisaroundtown]

The macro recorder unfortunately doesn't record this action for some reason.

On searching this website though I found this thread thread68-820062 which points to this website

http://www.rondebruin.nl/sendmail.htm#body.

Thanks for your help everybody.

Chris