patgenn123 Posted December 5, 2006 Report Share Posted December 5, 2006 I have a program that strips an attachment from Microsoft Outlook and puts it in a general folder. I would like to be notified of it when it hits this folder and then prompted to change the file name. Of course I want to open to see the file first before I rename it. After that I would like to move the file to a corresponding folder that matches a part of the file name. For example, an e-mail comes in from John Smith. John Smith has just sent me his proposal. A message box just tells me that I just received an attachment.(It would be great if the message box could tell me the name of that file before I change it). John has the name of the file to be XYZ.pdf I would like to have this file open first(to see what it is), rename it by prompting me, and then sending this file to another folder that matches part of the renamed file. For example, XYZ has been changed to "John Smith Proposal" from the prompt. I need to send this to another folder called "Proposal" where all the rest of the proposals are. How could I do this? Your help would be greatly appreciated!!! Quote Link to comment Share on other sites More sharing options...
patgenn123 Posted December 6, 2006 Author Report Share Posted December 6, 2006 I guess no one wants to help me??? I am trying my hardest to understand this program. It has given me much nervousness and anxiety, but it's still not clicking in my head regarding the logic and technical words needed to understand. If no one wants to help me, can someone direct me to where I need to start understanding basic computer programming so I can do this? I am very frustrated right now. I am not asking someone to write this whole thing, but if I can have pieces parts(and the logic behind it) so I can slowly understand, it would be greatly appreciated. All answers are welcome. Pat Quote Link to comment Share on other sites More sharing options...
Dan H Posted December 7, 2006 Report Share Posted December 7, 2006 Hmm... can see how to easily do everything you want, except open the attachement part. I have a somewhat simular macro that works with Groupwise email... it first checks 4 pixel locations to see if there are attachments, then if there are it saves those to a specific directory while remembering the files names for use later in macro, at which point it add's those files into a form that the macro is designed to complete for me. Here's a copy of that section of my macro.. maybe you'll get some inspiration from it: Macro Playback Speed: 3 Times Faster than Normal Audio Mute Window Resize: Current Win - (Width: 551, Height: 417) Get Pixel: Window Coords: 115,325 into %N3% Get Pixel: Window Coords: 190,325 into %N4% Get Pixel: Window Coords: 265,325 into %N5% Get Pixel: Window Coords: 340,325 into %N6% If Variable %N3% <> 16777215 Mouse Move Window 115, 325 Mouse Right Button Click Delay 1 Seconds Text Type: s Delay 1 Seconds Clipboard Copy Variable Set String %T11% "c:\macrotemp\" Variable Set String %T12% from Clipboard Variable Modify String: Append %T12% to %T11% Delay 1 Seconds Text Type: %T11% Delay 0.5 Seconds Text Type: <ENTER> Text Type: y Wait for Not Mouse Cursor: Hour Glass Delay 0.5 Seconds Variable Set String %T12% "%T11%" Else End If If Variable %N4% <> 16777215 Mouse Move Window 190, 325 Mouse Right Button Click Delay 1 Seconds Text Type: s Delay 1 Seconds Clipboard Copy Variable Set String %T11% "c:\macrotemp\" Variable Set String %T13% from Clipboard Variable Modify String: Append %T13% to %T11% Delay 1 Seconds Text Type: %T11% Delay 0.5 Seconds Text Type: <ENTER> Text Type: y Wait for Not Mouse Cursor: Hour Glass Delay 0.5 Seconds Variable Set String %T13% "%T11%" Else End If If Variable %N5% <> 16777215 Mouse Move Window 265, 325 Mouse Right Button Click Delay 1 Seconds Text Type: s Delay 1 Seconds Clipboard Copy Variable Set String %T11% "c:\macrotemp\" Variable Set String %T14% from Clipboard Variable Modify String: Append %T14% to %T11% Delay 1 Seconds Text Type: %T11% Delay 0.5 Seconds Text Type: <ENTER> Text Type: y Wait for Not Mouse Cursor: Hour Glass Delay 0.5 Seconds Variable Set String %T14% "%T11%" Else End If If Variable %N6% <> 16777215 Mouse Move Window 340, 325 Mouse Right Button Click Delay 1 Seconds Text Type: s Delay 1 Seconds Clipboard Copy Variable Set String %T11% "c:\macrotemp\" Variable Set String %T15% from Clipboard Variable Modify String: Append %T15% to %T11% Delay 1 Seconds Text Type: %T11% Delay 0.5 Seconds Text Type: <ENTER> Text Type: y Wait for Not Mouse Cursor: Hour Glass Delay 0.5 Seconds Variable Set String %T15% "%T11%" Else End If Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.