This method removes duplicates and all info but email addresses and sorts leads.

I save all files I make to DESKTOP in XP or Vista.  After uploading leads in Veremail, I put the lead files I created in designated folders.

I like to use the mouse wherever possible instead of keyboard commands.

 "Click" means left mouse click unless "right click" is specified.

Downloading leads from FFA and Etracking and Webcatch

After logging in on left side of FREE FFA page and page morphs to next page. Second entry on the top row (after setup), is FFALEADS. Click FFALEADS .  It will take a few seconds to a minute or more for your leads to appear.

a. When leads appear on FREE FFA page, right click on window with leads, choose select all, right click and choose copy in highlighted area, right click on empty notepad window and choose paste.

Then on notepad click EDIT, then choose REPLACE from menu. The Replace window appears, click , (comma), on your keyboard. This will activate buttons on right side of Replace window. Click REPLACE ALL button in Replace window.

b. eTracking and Webcatch; Copy/paste leads to same notepad following last FREEFFA's lead.

 Process: At eTracking or Webcatch after logging in and clicking View and Download My Contacts button. Left click start of leads and hold mouse cursor while moving the cursor down over all leads till all leads are highlighted, then right click in highlighted area and choose copy go to notepad window and right click and choose paste with cursor on first row after last lead from FFA site. Same process with eTracking and Webcatch leads.

c. We need to remove a space for proper sorting and duplicate removal. To do this with REPLACE window still open, hit your space bar on your keyboard 1 time, click REPLACE ALL button in the column on right, wait while the spaces are automatically removed. (about 15-30 seconds with XP, Instantly with VISTA).  Hour glass may be visible while spaces being removed in XP, or you may see the little grey removing box moving down your list.  When done close little REPLACE window by clicking X box top right corner.

 d. Save and assign name to notepad and save to desktop or wherever and leave open for further use.

Keys on your keyboard you will, or may need to use for the following process.

Sorting and filtering leads

a. Go to notepad window and right click on window with leads, choose select all, right click and choose copy in highlighted area, on CALC worksheet, right click in A1 cell (Column A Row 1), on CALC page and choose paste.

b. Text import window opens, click/check in comma, (there should already be a check in TAB) click OK.

c. Close notepad. We will no longer use this notepad file. I save mine till I have completed this entire process incase I goof up I can always start over, but when done I delete it.

3. On CALC work page, Click on A BOX, (for A column), (highlights whole A column), right click on A column box, choose DELETE COLUMNS from menu.

b. Column B with email addresses becomes A column. Expand column A now to see whole email address by placing cursor between A and B top of columns and while holding cursor with arrows showing, move to right to desired width of column.

4. Click on  B Column Box that now has date stamps in it, hold left mouse button down and drag cursor through several following column boxes hiliting several columns

b. now you should only have email entries in A column and no other info on page at all.

b. Top half of Standard filter window opens. In FIELD NAME (will show A1 email address), click scroll arrow and choose NONE, now click MORE on bottom right side of Standard filter window, Bottom of Standard filter window opens.

 Now you must click in this EXACT order....  4 clicks... Click/check COPY RESULTS TO..., left click in B1 cell on CALC work page, Click/check NO DUPLICATION box in standard filter window, click OK top right of Standard Filter window..

Note:Use this exact sequence of clicks for filter process, if you get out of order just cancel filter and start over.

c. Right click A BOX  (for A column), on CALC work page (A column should highlight). Choose DELETE COLUMNS. B column should move to become A column.

d. Widen A column with placing cursor between A and B top of columns and when you see arrows move cursor to right to desired width.

Sorting is done.

Give A Column a quick scan for junk or a empty cell. Delete any blank, date, or useless rows that might appear in visible rows on CALC work page in column A by right clicking in that row number and choose DELETE ROW.

Left click and hold cursor down on that last lead (hiliting it), while pressing and holding shift key down, keep shift key down and release cursor button, then with mouse use scroll handle right side of window to go to top of page and then click in 1A cell, all this time holding the shift key down. The whole column of leads should be hilited now. Let up shift key, right click on hilited leads and choose COPY, go to fresh notepad and right click and choose PASTE. Then on notepad click FILE, then SAVE and enter your file name for your leads.

(You must copy paste this way because if you just hilite A column and Copy, it will include empty rows under leads to bottom of CALC work page.)

Do it however you like. Then click SAVE and close this notepad. Your leads are saved as a text "txt" file.

You are done collecting and processing the days leads.

Personally I can load 10,000 leads at a time in my Veretekk Gold System auto responder. I can load 10,000 leads several times per day if i like. Most autoresponder companies either, do not allow loading your own lists, only allow loading lead lists purchased from them, or charge exorbitant fees for loadinf lead lists and put small limits even with that.

Like I said I can load lists up to 10,000 leads at a time with no extra charges! I can do this several times a day if I wish. If I had 150,000 leads, I would just load 10,000 at a time 15 times without any additional charges.

Ask me about it if you're interested interested in a super marketing auto responder like I use.

email: leads at mimbiz.com

I am available to assist you. Please contact me if you need additional help with this process.

If you'd like some free useful marketing and SEO software go here:  SOFTWARE

You can email me; leads at mimbiz.com

Call: 206-202-1477 I will call you back ASAP.

Skype: mimbiz1 (text "leads"), when add to contacts

To our success, John