View Single Post
  #7  
Old April 1st 06, 12:14 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Retain attachment when replying

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.

Ads