#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
I have been playing with the Rules and I'm able to identify specific
email, move them to the necessary folder, run a script, and forward them on to the correct distribution group. I'm missing the script that will the file as an Excel document then reattach it. I'm thinking that a possible solution would be to have some code save the file to a particular folder then set a rule to open Excel. When Excel opens have a macro open my file and save it as the correct format. I'm not sure at that point how to call OL again and resend the file. Thoughts? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help - Word adds secret code? Copy to notepad? | andytaylor2006 | Word | 0 | 12-15-2006 11:00 PM |
Excel ->VB code for Checkbox (control toolbox) | kirkstyle | Excel | 0 | 08-16-2006 04:17 PM |
FileSaveAs with Code | bsmith | Office | 0 | 01-05-2006 08:43 AM |
Opening messages/Code/custom archive | jdd2 | Outlook | 0 | 12-20-2005 08:55 AM |
Delete excel files by code in Access | Barry Richardson | Office | 0 | 06-13-2005 06:26 AM |