Cory

Cool. What is your question?

I haven't looked at it in a long time so this might not be the case anymore, but I'll mention my experience long ago with this. 

I used the email function for a long time with good success, but then it stopped working when Microsoft required a TLS encryption. I don't think MEP supports SSL or TLS and there are no options for it. My fix was to use SendPulse. Provided you don't spend a large volume of email. it's a free SMTP server and didn't force the user to encrypt.

MEP has error handling. Read the help file "Catch Error / End Catch Error" section. When you are editing a command, look at the top and see there is an "On Error" tab. 

There are online verifiers. Though you might be then giving addresses to spammers. But they probably have them already. 

For things like this I often use a class in a programming language. Like if I have a URI I can create an object from string and if it's malformed, I'll get an exception. 

Also one can doan MX lookup for the domain to validate that portion of it. 

Send a test email.

All validations I've used. 

I apologize. My mistake. I didn't notice that they names and lineups of forums had changed. Mea culpa. Then it is I who should to the right thing and stop following and offering help in this thread. Saves me time too. 👍

BTW I've never agreed with ISS's confusing split in product versions and naming. 
On another note.... I have never understood why people would opt to spend dozens of hours on issues instead of just upgrading for a few bucks. Why make life more difficult? [rhetorical] I value my time more than that I guess. 

Live long and prosper 🖖

If you are working in MEP I recommend making a simple macro to demonstrate, exporting it to an MEX file, and sharing it here. This will preserve variables and such. We can then comment better and make tweaks and post back.

If you're not looking for a MEP solution or to at least learn how to do it in MEP, then I I'm not willing to install ME and try to recall how things were done way back then. Sorry.

Also this shoudl be posted in the appropriate forum where acantor and others who use ME can help you better. 

The version isn't important in this case. The basic concepts are the same. Off the top of my head the only thing you will need to compensate for are the variable limitations. Older ME has 4 immutable variable arrays and MEP has user defined variables. To me that feature alone was worth the upgrade, but that's up to you. 

A lesson for today! 
There are two views for the editor, normal and direct. Select from the view menu. In your example if If one copies the display text, none of the useful settings will be transferred. If i paste that in, which MEP understands, you will see it displayed as the normal text of "Variable Save: Save Integer Variables". If I open the command, I'll see the correct option is selected. 

Often in the past when I'd post samples, I would post them as the command text and the direct so one could see both. 

YOu might want to do a few of the MEP tutorials to get a better feel for things. ISS has some good stuff on their website. 

OldMacroDonald I know it's nice to just have someone do it for you, but it's also worth trying to work though it yourself. You will learn more in most cases. 

But I'm weird. I'm more the "teach a man a fish" instead of the "give a man a fish" kind of forum member. 🙂

Weird. I omitted the first lines and the first clump of commands came in as one Text Type sommand. Something it doesn't think is valid in there. Acantor I suggest in cases like this you simple export the macro to a MEX file in cases like this. ALso it preserves the variable definitions. 

First off you might be confused about something. You are running the macro in debug from the Scripting window. One only does this when testing or debugging a macro. Normally one runs a macro with all the MEP windows invisible with an activation like a keyboard shortcut. 

If you are intentionally debugging, that depends on the scope of your macro, window activations, and more things. Please tell me if you are trying to run normally or debug before I spend time explaining something unnecessarily. 

You could make a text file for the list. I would prefer to use the registry though. When the macro runs do a Text File Process and get the desired row. Then you would get and save the index (pointer) in another file or, as I prefer to do, the registry. Each time it runs, increment it and save the new value. In the Text File Process, abort at the desired line using the pointer. 

To the moon!

You're welcome

There is no command to write into a delimited text file. You have to do that yourself. I prefer and recommend you use tab as the delimiter as in most cases it will eliminate the need for quotes for text identifiers. I build it with arrays using tabs, carriage return, and line feeds special characters and stuff it in a variable and save that to file. It's handy to make another macro for this to keep as a function for other things. Here's a page I wrote on the special characters. Here's one I wrote about processing tabular data.  That should give you a JATO start. 

%ReadFromFPS_CSVFile%

I can't see your variable definition. What is the array size set to? And do you have it defined to be an array? IN the Variables property box you should have the box "Create as an array" checed and the number of elements you want below that. 

I think part of your message is missing. 

Gotcha. You would need to spend a little time learning the commands and concepts you would need to do that. 
There's no mass input capability? That's hard to believe. 

In cases like this you could do a semi-auto approach. It's easy to create a simple set of keystrokes from the CSV. Timing from page to page is often the place where it gets tricky. But if you're willing to do some keyboard time, it could make manual entry faster. I am imagining going to an input form and clicking in the first field. Now fire the macro and it types in all the fields. Maybe even click the OK button. Then pauses. Then when the server digests the new input you move to that first field and continue.

So you do this 900 times. That sucks but you avoid the more complicated parts and it would be much faster than manual. 

Or... Maybe not repeat. Maybe each time it fires it saves a file with the index of the line you just did. Then instead of looping the macro, it just goes to that point again. That way if something goes wrong, you're not stuck in a loop and having to restart the macro. I'd be happy to set up the framework for this for you.  You would just put your text typing in. Or send me the tabs and input fields and I'll do it for you. Make me a dummy CSV file too. 

1 hour ago, rberq said:

But if you learn Macro Express, you will doubtless find more uses for it in the future

Hear, hear. 

MEP is cumbersome automating large batches of anything on a webpage. There's no controls or such so one's best best is to develop a process using tabs and other keyboard commands. Timing is usually a PitA but if you're only doing it once, you could slow it down to a snails pace. But you need some checks in there so that it doesn't go off the rails. 

Something that works in a web browser would probably be better like iMacros. But it's not as easy to learn as MEP. 

Have you considered using the limited but free mailing services from providers like MailChimp or Constant Contact?

Good job. I was going to look for mine, but didn't have time. 

2 hours ago, acantor said:

I triggered the macro. It worked!

Congratulations

2 hours ago, acantor said:

I should have explicitly said, when setting the challenge, that a small error rate is acceptable!

Yup. My clients usually have an idea about something and want X. But they don't really understand the nature of X. So really they want Y. Y = their flawed concept of X. A good example is when Apple made the iPod beta users wanted a random shuffle mode. When they tested it they reported a flaw in the feature because sometimes a song repeated 2 or many times.... Ummmm... That is the nature random. Even with 60 songs one will hear some repeated as many as 5 times. So they changed it to the consumer's idea of random. 

I love the quote about AI generation art, or code. I paraphrase "AI requires a clear and considered definition of the requirements for the product from the customer.... I think we're safe." LOL. 

I was wrong, RegEx isn't perfect either. I was going to get the silver bullet expression to share and.... There isn't one. In my RegEx Buddy is a library of expressions and they include a test subject. There are 12 and none work on all and avoid all invalid. I wanted to share how funny this is in defense of being accused of underestimating as RegEx is much more capable and even it doesn't have a perfect solution. What was perceived by acantor as an overestimation was actually a gross underestimation. This is a great example of my axiom of "How ever complicated you think a thing is, once you research it it's always much more complicated." On the plus side I have some more examples to test for false positives and negatives. I was thinking f some examples to play devli's advocate to challenge your macros, but it's already been done. 

Just for fun... Here's the test subject:

Valid addresses:
================
president@whitehouse.gov
ip@1.2.3.123
pharaoh@egyptian.museum
john.doe+regexbuddy@gmail.com
Mike.O'Dell@ireland.com
"Mike\ O'Dell"@ireland.com
IPguy@[1.2.3.4]
The email address president@whitehouse.gov is valid.
fabio@disapproved.solutions has a long TLD
fabio@email.validating.solutions

Invalid addresses:
==================
1024x768@60Hz
not.a.valid.email
invalid@ifon.nonexistingtld
john@aol...com
Mike\ O'Dell@ireland.com
joe@a_domain_name_with_more_than_sixty-four_characters_is_invalid_6465.com
a_local_part_with_more_than_sixty-four_characters_is_invalid_6465@mail.com

This is the simple one. \b[A-Z0-9._%+-]+@[A-Z0-9.-]+\.[A-Z]{2,}\b It matches 7 of the valid samples but unfortunately it also matches 4 of the invalid. It comes with the note "Use this version to seek out email addresses in random documents and texts. Does not match email addresses using an IP address instead of a domain name. Requires the "case insensitive" option to be ON." Oh yeah, case sensitivity is fun too. In MEP I'd convery it all to lowercase first. But I think for your application this would be adequate. 

Oh, and then there's invalid TLDs. That would be an entire routine to itself. And normally I'd think to limit to 3 characters, but they changed that rule and there are many 4 now. I looked it up and there can be as many as 63 characters now in the TLD. Yikes. But if one only wants things that look like a valid TLD, then it's not an issue. 

Even this one tries to use RFC compliance rules and still misses 2. 

Yikes. Like she said when I asked if she had a husband, "It's complicated".