Formatting Leads and/or pulling them into Excell
Click Here For Free Tool If You Don't Have Windows Exel
OppSeekers
OppSeekers leads will come in a file that opens in NotePad � save them to your computer in a Doc. ( Name them something you will remember)
Now open Microsoft Excel (my version is 2003) go to the Data tab along the top and click on Import External Data � then click on Import Data
Select Data Source window comes up � choose Documents and click on the opp seeker file � then on Open
Click Next � then Delimiters click on Coma � then next and everything will show columns and click Next then on Finish
Your leads will be in the Excel file in the separate columns
Transfer leads from Excel to Notepad
Transfer leads from Excel to Notepad to make ready for BCC to email :
Click on the top of the column that has the emails and the whole thing will highlight � then right click on the column and click on copy
Go to the right of all the columns with info to an empty column or open a new doc and drop the emails in a blank column
Click the top name then hold the left click down and drag your cursor down 75 emails � lift your finger and they will remain highlighted
Then right click on the highlighted emails and then left click on copy
Open notepad
Then right click and left click on paste so your emails are dropped there
Click on Edit on the top of Notepad and then on Replace.
Type .com in Find What
Type .com; in Replace With
Repeat for .net - .org � and .edu
Check your list visually for www and erase them then right click on emails again and then left click on Select All then right click again and left click on Copy
Open your email program where you usually send an email and right click on the Bcc section under To and Cc and then left click on Paste � pasting the emails into the bcc section of your email � this is Blind Carbon Copy so no one else can see anyone elses addresses but you can send one email to everyone.
Send the same email to all 75 emails at a time � then go back in but wait at least a hour and do 75 more � this whole process takes less then 10 minute once you are used to doing it.
Transfer leads from Excel to Notepad for BULK EMAILER
Transfer leads to Excel
Go to the right of all the columns in Excel and pick a fresh column with no information in it - make it larger by dragging the cell with a letter in it to a size that will accomadate both the emails and first names then click on the top cell directly under the letter in the first cell down and Type a equals sign then the letter and the number the emails are in (ex. if the emails are in column A and the first names are in the column B) you would then type this formula in the top cell of the new column =A1&","&B1 and hit enter - the email and first name will now be in the this new column with a , between them - Just the format you need for the bulk emailer ( email,name )
Now Click on the top rectangle and it will outline it - put your cursor in the bottom right hand corner of that little rectangle at the top of the column and it will turn into a + left click and drag all the way down to the bottom of your leads and lift your left finger and all the emails and names will be merged into this column - you can now click on the letter at the top of this column and the whole column will highlight so you can copy and paste into notepad and save it with a name that is easy to remember - then in the bulk emailer you can upload this file
|
