Friday, April 23, 2010

Government Regulation and Compliance - Renovation Contractors

These are links and information pertaining to the new Federal law that came into effect as of April 2010. Contractors performing renovation, repair and painting projects that disturb lead-based paint in homes, child care facilities, and schools built before 1978 must be certified and must follow specific work practices to prevent lead contamination.

Published By: Knowledgeman
Published: 2010-04-23
Revised: 2010-04-23

Table of Contents
Government Regulation and Compliance - Main Page

New Federal Contractor License Required

Common renovation activities like sanding, cutting, and demolition can create hazardous lead dust and chips by disturbing lead-based paint, which can be harmful to adults and children. To protect against this risk, on April 22, 2008, EPA issued a rule requiring the use of lead-safe practices and other actions aimed at preventing lead poisoning. Under the rule, beginning in April 2010, contractors performing renovation, repair and painting projects that disturb lead-based paint in homes, child care facilities, and schools built before 1978 must be certified and must follow specific work practices to prevent lead contamination.

Information and Links To Get Licensed
EPA Requirements
Lead, Renovation, Repair, and Painting Program (Final Rule) pdf
Application For Lead Contractor Certification (LIBI-613L) (PA Dept L&I)
Accredited Renovation Training Programs

Other Related Information and Articles
New Contractor Certification May Cost You More (wgal.com)

Thursday, April 15, 2010

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