Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2007, 07:24 PM
unit213 unit213 is offline
Novice
code to save / rename / send attachments
 
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
  #2  
Old 09-26-2007, 08:15 PM
unit213 unit213 is offline
Novice
code to save / rename / send attachments
 
Join Date: Sep 2007
Posts: 2
unit213
Default

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?
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 09:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft