![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
#7
|
|||
|
|||
![]()
I'd probably approach it this way:
1) Have the macro that creates the original message with attachment put into custom properties for the worksheet: -- the address of the original sender (which may or may not be available from Outlook's Namespace.CurrentUser object, depending on your version and configuration) -- the addresses of the approvers 2) Have a second Approve macro in the spreadsheet that creates a new message, attaches the file, and sends it to the people whose addresses are in the custom properties of the sheet. 3) Put both macros on a toolbar in the worksheet -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "rrmando" wrote in message oups.com... Thank you for the reply. Yes, that is what I would like to do. First I was not sure if it was possible. Can you provide guidance on the "reply" functionality to force the attachment to remain with the replies or to always copy the original sender? Thanks again. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do you retain contact formatting | MEP of Americas | Outlook - Using Contacts | 0 | March 30th 06 04:42 PM |
retain notes info while adding new contacts to same co? | Bryan Ray | Outlook - Using Contacts | 1 | March 25th 06 09:48 AM |
Can't Retain Settings When Importing Contacts | Susieber | Outlook - Installation | 1 | February 22nd 06 11:35 PM |
Autosuggest doesn't retain names after restarting Outlook | Erica | Outlook - General Queries | 1 | February 7th 06 03:10 PM |
How do I automatically retain email addresses in my contacts? | jpickles | Outlook - Using Contacts | 4 | January 10th 06 10:50 PM |