Hi Frank
See
http://www.rondebruin.nl/sendmail.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Costa, Frank" wrote in message ...
Hello,
I'm trying to create a macro that attaches the active workbook to an e-mail message (outlook), and it assignes a
- Recipient
- Subject Line
And allows the user to review the message before it's sent out.
Everything works fine, accept for trying to attach the active worksheet as an attachment to the e-mail, anyone have any ideas on
how to do it?
Is there a class/member for the "Mail Recipient (as Attachment)" option located under "File-Sent To-"
I found the one for "Mail Recipient (for review)", but it's that the greates for what I want.
Thank you
Frank