techtraf

Hello all,

I have several folders name like 20110603_xxxxxx, 20110610_xxxxxx, 20110617_xxxxx, 20110624_xxxxx. Where x = different name. inside each folder they are more than one hundred (100) PDF files. I have a macro to do the following:

FTP Site Connect %T[1]%

Repeat with folder Return: Files Only (but i'm not sure if i have to choose folder only)

Place result In %T[2]%

I checked Return the full file path

FTP Send File

File Name: I put the entire path name\*%T[2]*% (i try to FTP all the folder that begin with 201106*.*) but i don't know which variable i should use to indicate the folder name.

End Repeat

FTP Site Disconnect.

Can anyone help me with this script? I'' greatly appreciate. I'm currently using Macro Express Pro. Also let me know if I need to attached my macro.

Thanks in advance,

Gerard

Hello all,

I'm trying to FTP several files to the client server, but I'm getting an error 'The handle is invalid'. What is that mean? When I try a third party such as WinSCP, Filezilla, or IPSwitch WS_FTP the files went we no problem. But when I try the macro it won't send the files. I attached both screens shot. Please let me know what you find out. Thank you.

NOTE: Below is the email notification I received when I try a third party software. But the main idea is to have one job running and schedule the files from Macro Pro.

Files Transferred: /GOFEDEXASYNC/REMIT/AA040811.EDI 29,584 Bytes 04/28/2011 2:22 PM Upload Finished

Transferred to/from: www.ec.fedex.com/GOFEDEXASYNC/REMIT

Status: Succeed

Thanks,

Gerard

FTP_Error1.doc

FTP_Error2.doc

Hi Terry,

Any suggestion on my issue? Any help will glady appreciate.

Thanks again,

Gerard

Thanks an advance Cory. Let me know when you're complete the script.

Hi Terry,

Sorry about my interpretation... I'm kind new to this and I don't know where to begin. All I need to do is to open each attachment and save it to the C drive instead me doing it manually. The client send the file every day and sometimes I forget to save it. Also when I'm not in the office no one do it for me.

Thanks again,

Gerard

Hello all,

I'm currently using Macro Express Pro. Can someone write me a script how to take an attachment file from the email and save it to a hard disc. Also I'm using Microsoft Outlook 2000 version and I'm running windows XP Pro version 2002 with service pack 3. Most of the time the email subject is the same. Your help with this matter will very appreciate.

Thank you,

Gerard

Thank you very much Kevin. The first code is working PERFECT for me. I appreciate your help.

Please anyone, I would like to delete the EOF marker in text file. In this case is locate at the very end of the file (left corner). Is there a way to remove that EOF marker programmatically using the macro script commmand? Please let me know.

Thanks again,

Hello all,

I would like to know how I can delete the last character at the end of the file. It's call End-Mark file. It looks like a square (). I would like to know if someone already have a macro to this step or let me know how to do it. I'm currently using macro pro.

Thank you all,

I have like this but it did not work. No file rename. Please help.

<VARIABLE SET INTEGER Option="\x00" Destination="%N[1]%" Value="0"/>

<REPEAT WITH FOLDER Path="\\\\web\\D\\FTP\\users\\FedEx\\Inbound" OnlyFiles="TRUE" Destination="%T[1]%" FullPath="FALSE" ProcSubfolders="FALSE"/>

<RENAME FILE/FILES Source="%T[1]%" Dest="\\\\web\\D\\FTP\\users\\FedEx\\Inbound\\Blend_%N[1]%" Progress="FALSE" Recurse="FALSE"/>

<END REPEAT/>

I have a client wants to FTP several files to our server about 45 of them each week. The files name are 96455878548202 etc... They are made up with 14 digits and they all unique. All I want to do is to go in that folder and rename each file as Blend_1, Blend_2 and so on...

Can someone write a little macro code step-by-step or show me how to do this project. I'll appreciate the help on this one. I have a deadline by tomorrow to finish this macro. Thanks again everyone.

Hi Alan,

Thank you for your response. I'm currently using Microsoft outlook 2000 SP-3 (9.0.06627). And yes, I'm new to macro express pro. I know it'll take all day and I don't have a clue where to beging. That's why i'm asking if anyone have a script like that or a similear one that I can use. I also can rewrite it to complete what I need. Please let me know.

Thanks,

TTC.

It is unlikely that anyone on this forum will be able to provide a script that does exactly what you want. Besides, we would need more information: Which email system are you using? Which version? And so on. And if your email client is configured differently than the person who wrote the script, the script may fail or malfunction. And because you are not sure how the code is supposed to work and what assumptions the developer made, you may have trouble figuring out what is wrong.

 

In other words, the macro you have it mind is best created by you!

 

The script that you want is an example of what I call a "disposable" macro. It fulfills a specific purpose. I develop a lot of disposable macros because it usually takes less time or less effort to automate a process than to perform it manually. A macro is disposable in the sense that you create the script, test it, debug it, refine it, use it, and delete it. (Or deactivate it. You may need it again or want to "borrow" the code for another script in the future.)

 

If you are new to Macro Express, this would be a great first project. It might take all day to script it, but once you figure it out, scripting will go a lot faster next time.

 

If you are using Outlook, the "secrets" of making a reliable macro to do what you want to do is to sort the messages so that the ones with attachments are grouped together, and then simulate the keystrokes to save all attachments. In Outlook 2007, these are:

 

Text Type (Simulate Keystrokes): <ALT>f // Alt + F activates the File menu

Text Type (Simulate Keystrokes): n // Save Attachments...

Text Type (Simulate Keystrokes): a // all

Hello all,

I have more than 300 files on my email. What I want to do is to create a script from the macro express pro, and tell it to go to that folder on my email and retrieve all these files and save them to my hard drive. I don't want to go one-by-one to save each file to my hard drive. If there's anyone have a sample of this script or already done it can you share with me. I'll greatly appreciate.

Thank you all,

TTC.