Computers For My Business - Email Mining The Web

These are links and information pertaining to mass emailing and website email mining.

Published By: Knowledgeman
Published: 2010-04-15
Revised: 2010-08-11

Table of Contents
Computers For My Business - Main Page

Small businesses that use mass emailing as a marketing tool to target their products and/or services can use software to mine potential customer emails. To mine emails from the Web you can either use MS Excel or purchase an existing email mining/extraction software from a email specialty software vendor.

Using Microsoft Excel 2007 as an Email Miner

Open Internet Explorer
Goto staff webpage of company website you want emails from
Copy url address: use this for an example: http://web.clarion.edu/SBDC/Personnel/default.asp

Block the url address, make it blue, Click and hold [ctrl] and Click [c]

Open Excel 2007
Click Data
Click From Web
In the New Web Query Window, In Address box, Click and hold [ctrl] and Click [v]
The Clarion SBDC staff page url should appear
Click Go
If any error messages come up Click No
You will notice a bunch of yellow arrows on the web page in the Web Query Window
Click the yellow arrow that has the area where the emails are located
It will make a box around the email area that you want
Click Import
All the text in that area will transfer to Excel

You can close the Web Query Window and clean up the excel spread sheet to have only email addresses in the first column (top to bottom) like this:
A1
sopher@clarion.edu
kroth@clarion.edu
.
.
.

You can save this file and use it to import data into a second party email blasting program or copy and paste emails into any email program.

In addition you can develop an Excel macro that automatically cleans the data and leaves only email addresses.

Or you can purchase an email extracting software that will do it for you:

Google Search: email extraction software

Other Related Articles, Information, and Links
Email Marketing Strategy and Tips