Add Current workbook as an attachment

[Costa, Frank]

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

 

[Ron de Bruin]

Hi Frank

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