We’ve had a few questions lately about how to send email using the SMTPSendMail function via the Office 365 SMTP server.
Until Macro Scheduler 14.4.02 which we have released today this wasn’t possible as explicit TLS was required and SMTPSendMail did not support it. We have now added this. So as long as you have updated to Macro Scheduler 14.4.02 (and you have a valid Office 365 account) here’s the code you need to send an email via the Office 365 mail server:
Let>server=smtp.office365.com Let>SMTP_AUTH=1 Let>SMTP_USERID=YOUR_OFFICE365_USERID Let>SMTP_PASSWORD=YOUR_OFFICE365_PASSWORD Let>SMTP_PORT=587 Let>SMTP_SSL=1 Let>SMTP_USETLS=3 SMTPSendMail>RECIPIENT_EMAIL,server,YOUR_OFFICE365_EMAIL,YOUR_NAME,SUBJECT HERE,BODY TEXT,
See also:
http://help.mjtnet.com/article/4-sending-retrieving-emails-via-gmail-ssl
Macro Scheduler 14.4.02 maintenance release is now available for download from the usual places.
For details of changes please see the history list here.
Our longstanding customers will know we’ve never really been into jargon here at MJT. Jargon in the IT industry tends to come and go. And there’s something quite amusing about a term that pops up and is touted as being some amazing new thing when it simply describes something we’ve been doing here at MJT Net Ltd for 20 years! On the other hand any term that helps to describe what we do is useful and I suppose it’s nice to know that finally, after all this time, what we do in our little niche of the IT world now has a name: Robotic Process Automation or RPA.
So those of you who have been using Macro Scheduler for a while know what RPA is, even if you’ve never called it that.
Robotic Process Automation tools allow you to create “bots” (we’ve always called them macros) to automate business processes (often by simulating a user). With RPA we automate repetitive tasks – taking the robot out of the human – freeing people up for more value-adding activities.
Our customers have been automating their processes robotically for years, ever since Macro Scheduler was first released way back in 1997.
I’m pleased to announce that Macro Scheduler 14.4 is now available.
Macro Scheduler 14.4 brings you some cool new Screen OCR functions with a handy little Screen OCR wizard to go with them.
We’ve also added a HoldKey function to make it easier to hold keys down or perform key repeats, a function to set the volume and a new Excel function to attach to an existing – already open – workbook. There’s a handy ArrayFind function to help you find an element in an array quickly and for those of you automating downloads from websites there’s the new IEDoDownload function which “auto-clicks” on IE’s annoying download bar and removes the need for the legacy download manager.
For the more advanced programmer there’s also improved variable type awareness to give you more control over how comparisons take place in complex expressions.
For a full list of changes see the version history here. For trial downloads go here. Registered users can download their copy/upgrade in their account here.
Did you know you can use Regular Expressions inside any of Macro Scheduler‘s window functions (e.g. SetFocus, WaitWindowOpen, WaitWindowClosed) so that you can match a window title using RegEx?
As an example someone recently asked us how they would match a window from an old piece of software where the window title was always the letter “b” followed by any 8 digits, e.g. b23425461. Macro Scheduler uses the PCRE syntax, so to match a window title like this we could use this expression:
^b\d{8}
If you’re new to RegEx this means: match from the beginning of the string (^), then match a “b” character followed by any digit (\d) 8 times. {8} means match the proceeding token 8 times. So:
Let>WIN_USEREGEX=1
SetFocus>^b\d{8}
I’ve posted a little about Regular Expressions before. This post links to some useful resources if you are new to RegEx.
Regular Expressions for Dummies
My Most Used RegEx
Remove Tags From HTML with RegEx
A customer filing PayPal disputes rather than emailing us and then, despite confirming that they have the software, failing to cancel the dispute and PayPal finding in their favour, leaving us out of pocket!
PayPal is costly and causes so many accounting headaches it isn’t true. I’ve a good mind to remove it from our site. How many people only buy because we accept PayPal? Anyone?
Another “customer” asking us to write a script, watching us write code, seeing it working, speaking favourably throughout the project at every step, never voicing any concern and then refusing to pay at the end. What’s the answer, lawyers and contracts, which would mean we’d have to put the prices up, or just stop offering script development services? Answers below.
Maybe give up completely. It isn’t what it used to be. This was fun in the early Internet days. Now it just feels like everyone wants something for nothing. Convince me otherwise below.
Prompted by a recent forum post from Phil Pendlebury the other day I have written a new article on using XMLParse in the knowledge base:
Parsing XML with XMLParse and XPath
Hope it’s helpful. I’m sure you’ll have more questions when you start using it in anger. So when you do, be sure to head over to the forums and ask for help.
Did you know that we offer script development services? If you’re pushed for time or need a helping hand we can usually be of assistance. We often help people who don’t have the time or resource to build the automation themselves, or just want to get a jump start.
What sort of things do we do? It’s pretty much anything that needs automating, but a common scenario is data entry – usually reading data from Excel and entering it into either a web form or desktop app.
Recently we’ve written a script for a government agency which searches through hundreds of files looking for patterns and attaching them to emails; We’ve written a data entry script for a large oil company which reads through Excel and outputs the data to a web form; Helped a hospital automate entry of patient referrals into a web based system. We’ve reformatted CSV files; scraped data from a website; extracted data from PDF and output to Excel; Extracted patient data from an online dental patient database; assisted with extracting reports from an ordering system; and more.
So you can see we do all kinds of things. We have been automating processes for 20 years. If you have a project you could use some help with give us a shout and we’ll see what we can do.