cyberchief

That may have solved the problem... I should have known (always have been good about trimming and removing any carriage returns). Now, getting another error that I think is internal... (server authentication error). Working on getting info from the exchange team. THanks much!

What kind of program are you typing it out into? Does that program have limited characters in the feild?

I have. I get an error "501 5.5.4 Invalid Address".

I am running the latest version (3.5e). But it is not allowing me to do this. Whenever I click OK, the %T1% disappears from the "TO" Feild.

I am trying to create a Macro that will copy some cells including Recipient name and company name from an Excel file. The Recipient name will be in the form of an email address. I need the Macro to send an email to that Recipient email address. I have tried setting that email address to %T1%, then in the "send email" properties, in the to field, I have put %T1%. I exit that, reopen and the %T1% disappears. Is there a way to have the email sent to that variable recipient?

Kevin, The problem with your suggestion is that, I have the shared desktop from the other computer which will just be within another window. Activating the hotkey will automatically send it to my computer and the other computer will not take it. Well, although I was able to verify this would work on MY computer... I just tested my work-around on one of the other computers through the shared desktop. It wouldn't work. But, I can right-click RUN on those mex files... so I guess I still accomplished what I needed to do. Just creating a little shortcut rather than going "file, open," and navigating to the correct program. Thanks!

I figured it out for now.... The Main.mex file is in a different directory than the macros I am running for the other computers. Main.mex is on the H drive and the others are in the Z drive (both on network). Under Activation, on the window category, I selected the Z drive directory. now, it will run only if the current macro file is under the Z drive. Works fantastic. If anyone still has any ideas as far as scope goes... in the case that the main.mex file is ever under the same directory, please feel free to post ideas.

I run ME on mulitple computers... and control them all on my PC via netmeeting (shared and control desktop). When running programs, I find that I need to modify the macro program. I normally pull up that macro on ME on my desktop, make changes, save, then open up that computer's desktop, and re-open the macro file so that computer sees the changes. I have 4 other computers right now... each with a mex file associated with them (Macro 1.mex, Macro 2.mex, Macro 3.mex, Macro 4.mex). I thought of creating a Macro that will automatically re-open the file. This works... except for the fact that, since ME is running on my desktop, MY ME will run rather than the one on the computer I am controlling. I set the hotkeys for the computers that are running... but my ME mex file does not have that hotkey in use... so it is normally not a problem and the ME on the computer will take the hotkey and run. What I want is a way to create a scope that will run this macro as long as the current mex file is not Main.Mex. Is there a way to do this? To create a scope that will run this macro anytime the current loaded mex file is not "Main.mex"? Here is the code I created: Set Variable %T1% to "Preferences Registry Key" Read Registry String: "Current File" If Variable %T2% contains "Macro 1" Program Launch: "Macro 1.mex" Else If Variable %T2% contains "Macro 2" Program Launch: "Macro 2.mex" Else If Variable %T2% contains "Macro 3" Program Launch: "Macro 3.mex" Else If Variable %T2% contains "Macro 4" Program Launch: "Macro 4.mex" Else If Variable %T2% contains "Macro 5" Program Launch: "Macro 5.mex" Else If Variable %T2% contains "Main" End If End If End If End If End If End If <VSETMISC:T1:Preferences Registry Key><REGRSTR:2:%T1%\Miscellaneous\Current File><IFVAR2:1:02:7:Macro 1><LAUNCHDEL2:0:01Z:\H_Drive\Gba\QMacro\Main Macro File\Macro 1.mex><ELSE><IFVAR2:1:02:7:Macro 2><LAUNCHDEL2:0:01Z:\H_Drive\Gba\QMacro\Main Macro File\Macro 2.mex><ELSE><IFVAR2:1:02:7:Macro 3><LAUNCHDEL2:0:01Z:\H_Drive\Gba\QMacro\Main Macro File\Macro 3.mex><ELSE><IFVAR2:1:02:7:Macro 4><LAUNCHDEL2:0:01Z:\H_Drive\Gba\QMacro\Main Macro File\Macro 4.mex><ELSE><IFVAR2:1:02:7:Macro 5><LAUNCHDEL2:0:01Z:\H_Drive\Gba\QMacro\Main Macro File\Macro 5.mex><ELSE><IFVAR2:1:02:7:Main><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF><ENDIF>

I think these are "Carriage Returns". Try this: Clipboard Copy Variable Set String %T1% from Clipboard Variable Modify String: Strip CR/LF from %T1% Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T2% from Clipboard Variable Modify String: Strip CR/LF from %T2% Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T3% from Clipboard Variable Modify String: Strip CR/LF from %T3% Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T4% from Clipboard Variable Modify String: Strip CR/LF from %T4% Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T5% from Clipboard Variable Modify String: Strip CR/LF from %T5% Text Type: <ARROW RIGHT>

I am not sure why the next "copy" would not switch focus. I use excel with every macro I build... I copy the first cell, arrow right, and copy again... If you copy one cell manually... and arrow right 10 times... you will see that the "marching ants' is still going around that first cell. this does not mean that it still has focus... if you clipboard copy again... on the new cell that you arrowed to, it will move the "marching ants" to the new cell. If it does not work with "arrow right"... try using tab. Please post the script of the macro you are running... and I will see if I can find the error.

tatrader, Simple enough.. replace "text type macro: "controldown,C,countroup" with "Clipboard Copy". The cell already has focus... there is no reason to texttype. Clipboard Copy Variable Set String %T1% from Clipboard Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T2% from Clipboard Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T3% from Clipboard Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T4% from Clipboard Text Type: <ARROW RIGHT> Clipboard Copy Variable Set String %T5% from Clipboard Text Type: <ARROW RIGHT>

Joe, That was perfect. I don't know why... but it seems that I tried this exact same thing but could not get it to work. I must have had something missing. Anyway, thanks for your time and assistance!!!

Rather than using Repeat Stop... use "BREAK". I don't think you can have a Repeat Stop in the middle of an if statement.

Maybe not the best way... but.... I have ME on 4 other computers. I connect to these computers via NetMeeting and on each of these I select "Share Desktop" and "Allow Control". Basically, opens up a window on MY terminal that I can control all 4 computers from there. When I run the macro, I minimize the shared window. To view its progress, I maximize the window (but keep the mouse out of the window pane so as not to interrupt the macro running). Works fantastic for me.

Joe, Hope you are still around... Still need assistance with this one. I am not familiar with ACSII format... but hopefully soon will have time to investigate. What I need to do is: get the first line of 36 character (whole words) and type into a text feild. Tab to another field, type a code, hit enter, wait for fields to clear (thats what hitting enter does, does not go to the next line underneath... just sends the current data and clears the field) and repeat. So, basically, I need to cut up and type that information IN the loop that is breaking out the characters. Not append them to another variable with the carriage returns. Let me know if you have any ideas. If not, no prob. Thanks for any help!!!

Joe, Excellent code... But I do have to apologize that I didn't explain what i am actually doing... so that is my fault. What this code is doing is typing into fields that are only 36 characters in length. not on a notepad or anything. So I actually have to tab to the field, type out up to 36 characters, go to another field, type the word "more", hit enter, then tab tothe field again and repeat. This has to repeat for as many lines as needed. That is why I had the "repeat" that would type out the first line and hit enter, and repeat with the next line. I am going to look at your code and see if there is any way to add the repeat in there. If you have any ideas, can you let me know? Thanks much!!!

Thanks Joe! I will take a look at this. You know... as much as I THINK I know about writing macros... I am always humbled when I see your responses and try and work with them. I may be writing back with questions after I go through this. Thanks again!

Need help desperately. I am trying to cut up a length of text to type into fields that have a maximum length of 36 characters including spaces. Problem is that I don't want to cut up words (text can change depending on the project). So, I need to find the "space" prior to the 36 characters, and use that positioning to only input that text up to the space. Example, take the following text: and make it look like this: Here is the code... but it isn't working and I have been hammering at this for a while trying to figure it out. <TVAR2:11:01:-If you are reading this from an email system other than Lotus Notes, there are Lotus Notes document links that will not work on your email system. URL links (text that starts with><REP3:08:000002:000001:0011:1:01:T11><IFVAR2:1:11:1:><BREAK><ENDIF><TMVAR2:10:20:11:001:036:><REP3:01:000001:000001:00036:0:01:><TMVAR2:10:50:20:001:001:><TMVAR2:08:51:50:000:000:><TMVAR2:11:20:00:001:001:><ENDREP><IVAR2:01:13:51: ><NMVAR:02:01:2:0000036:1:0000001><NMVAR:02:01:1:0000001:2:0000001><TMVAR2:10:55:11:001:N01:><TMVAR2:11:11:00:001:N01:><TVAR2:51:01:><TEXTTYPE:%T55%><DELAY:.2><TEXTTYPE:<NUMENTER>><ENDREP> Variable Set String %T11% "-If you are reading this from an email system other than Lotus Notes, there are Lotus Notes document links that will not work on your email system. URL links (text that starts with" Repeat Until %T11% <> %T11% If Variable %T11% = "" Break End If Variable Modify String: Copy Part of %T11% to %T20% Repeat Start (Repeat 36 times) Variable Modify String: Copy Part of %T20% to %T50% Variable Modify String: Append %T50% to %T51% Variable Modify String: Delete Part of %T20% Repeat End Variable Set Integer %N1% from Position of Text in Variable %T51% Variable Modify Integer: %N1% = 36 - %N1% Variable Modify Integer: %N1% = %N1% - 1 Variable Modify String: Copy Part of %T11% to %T55% Variable Modify String: Delete Part of %T11% Variable Set String %T51% "" Text Type: %T55% Delay 0.2 Seconds Text Type: <NUMENTER> Repeat End Any ideas what I am doing wrong? I am sure it is simple... just can't find it.

Disregard... for some reason, my copy of an excel cell finds a CR... I modified to removed teh CR/LF, and it works. Thanks anyway.

I am sure there is a way to do this... but it escapes me. I want to open up a specific program file... using a variable. The File will be "H:\casper\%T1%.xls" . But I can't find what command to do this with. Any ideas?

Randall, Finally got time to play with this... but I seem to be getting an error... AutoIT Error Line 0 (File "C:\Program Files\MacroExpress3\MEbasicWizard.exe"): $CopySheet=$ExcelValuePass[2] $CopySheet=^ERROR Error: Array variable has incorrect number of subscripts or subscript dimension range exceeded. Any ideas? Also, do I need to have a blank xls set in the same directory before starting this? I thought I did... so I have and I set that in the macro.

Randall... you are a paradigm... or a pair of dimes... not sure. but you are amazing nonetheless. I am lost as what to do next or where to even start with this. I got the files... Here is what i need to do. I have 1 macro that pulls up each account and dumps the data into an excel spreadsheet in a specific folder. Each spreadsheet has the account number as the title. I need to extract line 2 from every one. Now, I am thinking I should use the spreadsheet that contains the account numbers in the column, copy the account number and set to variable... and use that variable in the macro to process the spreadsheet. Can you give me some pointers here??? I am looking at your code and having a hard time deciphering.

Sorry Randall.... been pretty busy... haven't had a chance to respond. I do not have the wizard installed yet... but I will look into doing this.

Thanks Radall and Kevin. I had tried both of them... but I can't seem to get any of them to work. The program I am using has windows within windows... but these individual windows are not recognized in MS Windows. just a pain. hey, you have any ideas on my other post?

I am working with a program where the control text changes with each account I pull up. The Classes are the same, but the text of the control changes to that of the account name. I need to click on a certain button which is itself a button. Problem is... I can't choose Get Control because that uses the current name... I can't choose capture because it could be anywhere on the screen. Is there a way to set a specific control through programming? I can get the account name off of the program... I would like to be able to use that to set the control text. but how do you do that and set the class to button without using the get control? Does anyone have any other ideas?