Email selected worksheets from a workbook as attachment.

[osoloco]

I need to find a way to email selected worksheets from a workbook as
attachments.
I've found a sharware program called PATools but I'd like a better way if it
exists.
Thanks for any help.

[Norman Jones]

Hi Osloco,

>I need to find a way to email selected worksheets from a workbook
> as attachments.
> I've found a sharware program called PATools but I'd like a better
> way if it exists.

Ron de Bruin has sample code at:

http://www.rondebruin.nl/mail/folder2/mail3.htm

See also Ron's main Email page at:

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

If you are not familiar with macros, you may wish to visit David McRitchie's
'Getting Started With Macros And User Defined Functions' at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm


---
Regards,
Norman