Jump to content
Macro Express Forums


  • Content count

  • Joined

  • Last visited

  • Days Won


rberq last won the day on July 7 2017

rberq had the most liked content!

Community Reputation

11 Good

About rberq

  • Rank
  1. Gmail / Googlemail settings

    Are you saying you have it working with Macro Express? What settings?
  2. Gmail / Googlemail settings

    Here are a couple links I found through Google. I tinkered a bit but didn’t get it to work yet. Basically a script file and a batch file to execute the script. If you can get it to work then you can run (launch) the batch file from Macro Express. Script “testgmail.ps1”: $EmailFrom = “myemailname@gmail.com” $EmailTo = “addressee@yahoo.com” $Subject = “test subject line” $Body = “test text” $SMTPServer = “smtp.gmail.com” $SMTPClient = New-Object Net.Mail.SmtpClient($SmtpServer, 587) $SMTPClient.EnableSsl = $true $SMTPClient.Credentials = New-Object System.Net.NetworkCredential(“myemailname”, “myPasswrd”); $SMTPClient.Send($EmailFrom, $EmailTo, $Subject, $Body) pause Batch file: cd\windows\system32\WindowsPowerShell\v1.0 powershell c:\temp\testgmail.ps1 pause https://superuser.com/questions/80255/send-email-via-gmail-from-command-prompt https://www.howtogeek.com/120011/stupid-geek-tricks-how-to-send-email-from-the-command-line-in-windows-without-extra-software/ Edit: edited this post to give the script file name the extension "ps1" instead of "txt".
  3. Gmail / Googlemail settings

    I tried your settings with Macro Express version 3 and got the same error you did. I changed the port to 25 and got the "success" message from two send commands, and the ME email log showed success, but neither recipient got the mail, and my gmail account does not show the messages in its Sent folder. Sorry, no help from me. But please post again if you figure it out because it would be handy to have it working.
  4. Very clever. So when you have extracted an item from the list, on the next pass you can type the item then <ARROW DOWN> to get the subsequent item, and so on???
  5. If you have to do it on a regular basis, experiment with Page Down followed by Arrow Down -- loop within loop. It might work if Page Down consistently advances by a predictable number of rows. (What the heck, you have solved your problem, but aesthetics demands an elegant solution instead of brute force.)
  6. Make peace. I don't understand why this is a problem. If you want fewer passes through the Repeat loop -- lower processing overhead -- do something like Variable Modify Integer: %x% = %x% / 10 Repeat with Variable: Repeat %x% times Text Type: <ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN><ARROW DOWN> End Repeat Or put the loop in a separate macro that you call (run) from your main macro. It will at least LOOK a little cleaner.
  7. Problem pasting to PaintShop Pro

    If the Launch command is freezing ME, you could try launching PaintShop Pro indirectly. Write a simple batch file "start_paintshop.bat" which consists of two lines: start c:\path\paintshoppro.exe exit Then in your macro, launch the batch file: ProgramLaunch c:\path\start_paintshop.bat You might need a brief pause after the launch for it to complete, or a short loop to mark time until PSP is running. Might work.
  8. Can I, using one "if variable" statement, check to see if my generic variable has any ONE of those numbers and to return the message as a result? The short answer is no, you can’t. The longer answer is, take a look at SWITCH / CASE in the Help section. Still a lot of lines to code, but it’s more readable than a bunch of IF / OR / IF / OR … commands. How about dividing your result integer by 12, then checking the remainder? You would still need an IF or CASE for each month, but not half a dozen or so for each month. As far as I know, Macro Express does not just give you the remainder when you divide integers, so you will have to divide by 12 then multiply the result by 12 and subtract from the original. Or code a loop to subtract 12 over and over until the result is less than 12. If the data from the user is text you will have to convert to integer (Variable Modify Text) before doing the math. Probably easiest of all: convert text string to decimal, divide by 12, and check the decimal portion of the quotient to determine the month -- 0.08 is January, 0.16 February, 0.25 March, and so on.
  9. I have never worked with macros on two monitors, but I will take a stab at your problem. Maybe someone else will step up and give a better answer. 1) You can use command "Variable Set Integer" to get location/coordinates of the current window. So if the relevant application's window has focus you can check which monitor it is on. You may be able to get coordinates also with the "Get Control" command even if the window doesn't currently have focus -- I'm not sure of that. 2) When you code a menu in Macro Express, you can tell it the coordinates at which to display the menu, so hopefully you can pick spots that are reasonable on each monitor even if people use different resolutions. (You can get their screen resolutions also by the "Variable Set Integer" command, if you need to.) I don't think you can change, on the fly, the location to display the menu. But you could code the same menu two times in the macro, at different display locations, and say something like IF WINDOW-TOP-LEFT-CORNER LESS THAN 1920 DISPLAY LEFT-MENU ELSE DISPLAY RIGHT-MENU END IF I know you said you would like to tether the menu to a program, but the best I can come up with is to check window name(s); and code some logic to position the menu because I don't think it can be automatically tethered. Good luck, feel free to ask more questions, and let us know how it works out.
  10. Announcement: Macro Express v 3.11a

    www.macros.com/download.htm You should be able to apply the same license code you used for your initial installation and for your last upgrade.
  11. Saving to Excel in background

    Automated. The macro scans the clipboard text for identifiers, then finds a value after the third subsequent dollar sign for each identifier.
  12. Saving to Excel in background

    I have a macro to do a similar thing, but on a smaller scale -- a dozen or so values rather than your 50. Rather than use a text file, I copy the whole screen to the clipboard, extract the fields I want into ME variables, switch once to Excel, Ctrl-Home to the first cell, and type arrow keys to get to the desired cells to type the variables. It is very fast and reliable, but it doesn't do Excel in the background like you would prefer. The logic to make sure there are no missing fields is in the extraction macro.
  13. Good thinking! Though I can't quite "logic" out why that works. I would have guessed Repeat Delay would make the difference, rather than Rate. Now that you have me thinking about it, I lengthened my Repeat Delay, because maybe the short delay accounts for some of the the double-character errors I have been making lately with my typing. I was blaming sluggish fingers or sticking keys, and it never occurred to me to blame the keyboard settings. (Sorry, this has nothing to do with ME macros, I'm just happy to get rid offff thoose exxtra chaaraactters I have beenn typping.)
  14. Just as an experiment, try "Keystroke Speed: 1000 Milliseconds". It will be excruciatingly slow, but if it works then you know timing is the issue and you can experiment with other speeds. Or maybe do the opposite of my second suggestion: use the Text Type option that pastes from clipboard. Though that option has always been troublesome for me.
  15. I have seen this behavior on rare occasions, but don't recall that I ever really figured it out. A few things to try: 1) Set keystroke speed to a reasonable value -- I generally use 30ms, but that's just an arbitrary value. 2) If you are using the Text Type option that pastes from the clipboard, don't use it. 3) Try typing a few blanks, then type the same number of backspaces to get back to the beginning of the field, then type the real data. That has worked for me sometimes. I know, it's sort of a Mickey Mouse fix, but if it works ...