Add Current workbook as an attachment
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 |
Add Current workbook as an attachment
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 |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com