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

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