Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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

All times are GMT -7. The time now is 12:21 AM.


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