Ever tried to send out an ACT eMarketing campaign and had it fail with a Send error? The typical reason is because one or more of the email addresses within the group that was sent to was either blank or malformed (example#example.com, example@examplecom).
There is a toolset that can help fix the emails in your database quickly without having to do a tedious one by one search. The tool set contains a spreadsheet that will find bad emails and also a plugin that lives inside ACT that will build a group of bad emails.
The downloads for the tools are at the end of this article. Here’s how you use them.
All of the invalid email addresses will either appear at the top of the list or the bottom in red depending on the sort/filter options. Now you just need to go back into ACT and fix the ones found in the spreadsheet. Or set your duplicate checking to emails only, use that as the duplicate check and reimport the contacts – having a column with the emails fixed – import it into a different temporary user field and then copy over to the bad email address. You would, of course, need to save a lookup of what you just imported. This would be the way to manage a lot of bad email addresses versus fixing them one at a time.
A plugin has also been provided that once installed is run from within ACT. It will find bad emails and add the contacts to a group.
Work through the list of email addresses and correct them.
File Attachments – note you may have to open Windows Explorer and “unblock” the file using the properties on right click. Some Windows will “protect” you by blocking the file.