Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Email selected worksheets from a workbook as attachment. | Excel Worksheet Functions | |||
HOW TO PUT MORE THAN ONE WORKBOOK ATTACHMENT IN AN EMAIL? | Excel Discussion (Misc queries) | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
Send active workbook as attachment | Excel Programming | |||
Send current Excel File as an attachment using Outlook 2000 | Excel Programming |