View Single Post
 
Old 09-26-2007, 07:24 PM
unit213 unit213 is offline
Novice
 
Join Date: Sep 2007
Posts: 2
unit213
Default code to save / rename / send attachments

Hi all,

I've searched the site and I didn't see a solution to my issue. I'm
hoping that someone can point me in the right direction...

Here's what I'm trying to accomplish, most likely by VBA code,
but any working solution would suffice:

I have rules setup to route any new email with a .csv attachment
and the word "test" in the subject line to a folder called "Reports".

I'm looking for some code that would identify new email in that 'Reports'
folder. I then need OL to either save the file as an Excel document
or change the file extension to .xls. I would much rather the file
get saved as an excel file to a temporary location (desktop).

Once that is complete, I need OL to attach the file to the original email
that it was sent with and have it re-sent to the sender.

Possible? A VBA solution or a combination of that and using the rules
would be fine also.

I know that it's an odd scenario. Any help would be greatly appreciated.

Thanks.

Note: I'm running OL 2003 BTW.
Reply With Quote