Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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



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 02:52 PM.


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