The Email Extractor is used to extract email addresses from any text file or from Eudora’s mailbox file (.mbx file).
NOTE: The Email Extractor will not be able to extract email addresses from Microsoft Outlook products.
1. Open Mailloop and from the Tools menu select Email Extractor.
2. In Step 1, select the file or files that you want to extract the email addresses from by clicking Add File(s). For In this example we are adding a text file called “Test_Document.txt”.
3. In Step 2, since this is a text based file we select “Treat all as RAW data (text)”. If the file was a .mbx file we would select “Treat as .mbx Files” and the “Split names into first and last” would become available. If you select this option then the resulting first and last names would be split up by commas. If this option is not selected then the first and last name are saved as one text string.
4. In Step 3, since we have selected a text source file, the only option available to us is the “All email addresses” option. If we had selected a .mbx file then the “Only extract from the following field” option would be available. This option allows you to specify where to extract the email addresses from. The options include From, To, and Subject.
5. In Step 4 select one of the four save options.
Save results in a quote-comma-delimited format: this will save the file in the following format:
“[email]”,”[firstname]”,”[lastname]”
“john_wayne@mailloop.com”,”John”,”Wayne”
If the file exists, append the results to the end of it: This will save the results to an existing specified file
Verify the email address (using RFC email rules): This is used in conjunction with the “bad email address” option below. This applies to a failed syntax validation. This feature checks for certain built in rules for email addresses to ensure that they are valid. However this is not a very strict validation. You may want to check the “bad email addresses” file for any “good” email addresses.
Create Separate files for results from each source file: If you have multiple source files in Step 1, this feature will create separate result files for each source file. If you choose not to select this option then it will simply create one file of all the email addresses.
In this example we are selecting “Save results in a quote-comma-delimited format.”
There are an additional four options available when selecting a file to save the email addresses to. These options include:
Save extracted email addresses to: you will need to specify a text file to save the email addresses to. This can be done by selecting the Browse button and locating your text file.
Save bad email addresses to: This is used in conjunction with the “Verify the email address” option above. This applies to a failed syntax validation. This feature checks for certain built in rules for email addresses to ensure that they are valid. However this is not a very strict validation. You may want to check the “bad email addresses” file for any “good” email addresses.
Use exclude file to remove email addresses: This allows you to specify an exclude file that the Email Extractor will use to cross reference any emails that you want excluded from the resulting file.
Save excluded results to: This will display the output of any excluded email.
In this example we are selecting the “Save extracted email addresses to” option and save the results to the “Extracted_Emails.txt” file.
Check List: before you select the “Start Extracting” button please ensure that you have selected ALL the proper settings and options outlined above.
§ Is your source file a text file or a .mbx file?
§ If you added more than one source file are they the same type? You will not be able to extract .mbx and text files at the same time.
§ Did you select all the proper Save Options?
§ Did you specify a file to save the email addresses to?
§ Did you specify the FULL path to this new text file?
6. Click Start Extracting.
The Results Summary will display the number of emails that were extracted, the number of duplicates, the number of bad emails, and the number of excluded email addresses.
The resulting “Extracted_Emails.txt” file will look like this:
As you can see the two email addresses in our original file have been extracted and properly formatted with the header and with quotation marks around the email addresses.
Extracting the Address Book from Outlook Express
Putting your text file into Mailloop format