This method removes duplicates and all info but email addresses.

 This entire process as described below usually takes about 10-15 minutes once you are used to it.  That includes collecting leads, processing and 10,000 loaded and sent out via Veremail.

I am not an expert and I encourage you to experiment with the software and share methods if you find easier or better ways of accomplishing this task or steps within this task.

I do have the complete Microsoft Office suite, but use Open Office to better my knowledge of it so I can share with others that do not have Microsoft Office software. I find it to be as easy to use for most things I do. I am not making a statement for or against either or any product.

I save all files I make to DESKTOP in XP so they are easy for me to find. With Vista I save to folders on my desktop. Then with XP 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 1 time. Do not click it a second time for any reason! It will take a few seconds to a minute or more for your leads to appear. (If you click a second time, you will get no, Zero, 0 leads!)

a. When leads appear at 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.

b. eTracking and Webcatch; Copy/paste leads to same notepad following last FFA'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. Remove spaces: Usually about 50 entries will have a space preceding the text in column A . We need to remove that space for proper sorting and duplicate removal. To do this you click EDIT at top of notepad, click REPLACE in window that opens, hit your space bar on your keyboard 1 time, click REPLACE ALL 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, or you may see the little grey removing box moving down your list.  When done close little EDIT window by clicking X box top left 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, right click in A1 box (Column A Row 1), on CALC page and choose paste.

b. Text import window opens, click/check in comma, (also 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.

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

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 any box in C column

a.Click ctrl and down ARROW on your keyboard at the same time. This should take you to first entry in column C.

b. Right Click in box for that row in column A, right click and choose DELETE, in little window that opens choose move cells left, then ok.

c. Click on box in C column again, hit ctrl & down arrow at same time in column C again and repeat step 4b above.

Keep repeating this process till no more entries to process in C column. Then click ctrl & home or ctrl & UP arrow at same time to return to top of page.

D. If you wish to eliminate entire row. Instead of clicking box in A column, right click on row Number, (example 257), at beginning of row.

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

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

Range contains column labels should be checked automatically. Now you must click in this EXACT order Click/check COPY RESULTS TO..., left click B1 box on CALC work page, Click/check NO DUPLICATION box

KEEP FILTER CRITERIA should have box checked automatically. Click OK.

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 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.

b. Click OK. Ascending should be chosen in first 2 boxes of this window automatically. Primary Sorting is done.

Right click and delete any blank or useless rows that might appear near first few rows on CALC work page in column A.

Left click and hold cursor down on that last lead (hiliting it), moving cursor up a couple leads 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 on 1A box, 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 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.)

Example: I would call this lead list 1 for the first day of July, 07 for the year jul for the month, 1743 for the number of leads. Mine would look like this 107jul1743

Do it however you like. Then click SAVE and close this notepad.

You are done collecting and processing the days leads. If you are not going to add previous leads or other leads you may have then you can close and Discard your CALC work page if you wish at this point, but if you want to add leads as I do so I am sending 10,000 every day, do not close CALC work page and continue........

To add leads for bigger list:

Go to work page and click ctrl and end keys at the same time. (you should be at your last lead)

click a box anywhere out of column A so Column A is not hilited.

Open your clean and sorted notepad list that you want to add. For me that would be the previous days 10,000 leads I sent via Veremail.

Right click anywhere in the notepad window and choose select all, right click in the hilited area and choose copy. close your notepad.

right click on the first blank box (below your last lead), in column A of CALC page and choose PASTE. Click OK when the text Import window opens.

Click ctrl & end simultaneously to see they are there if you wish, then ctrl & home simultaneously to get back to top of page to filter.

I now have 3 notepad lead files. First is when I originally saved my new leads before processing, named 1jul. I delete this file. I only saved it this long in case I goofed up somehow and needed to start over.

 My next notepad lead list is 107julxxxx (xxxx being the number of new leads from today), I move this to a folder I call clean leads. I leave my final list 107jul10k on my desktop with XP or in a folder with VISTA because I will be sending them and will add them to tomorrows lead list.

I don't save any CALC files, if you want to you can. I know I can always make a CALC file if I need one with my saved notepad files.

Log in to your Veretekk system. Click Veremail ( Middle choice in black bar top of page.)

Choose UPLOAD EMAIL LIST left side page,

scroll down to form area,

Box 1, Click browse to find your lead list, click your lead list file when you find it and it will automatically list itself in first box here.

Box 2. Enter name you want for your list. I use same one as name I gave it as example above this would be 107jul10k.

Box 3, Enter EMAIL SUBJECT that you want to appear on your Veretekk verification email message. You want to choose something that will entice people to verify to see your following messages.

Box 4, Choose the Veretekk email verification email you prefer. if you don't know what you like, you can click VIEW to see them.

Box 5, choose the Market center page you should have made for folks to see your bizop or whatever and click to go to the web page of your choice. If you don't make one, they will get you Veretekk default market center page which is always a choice.

Box 6 choose the Auto responder series of emails you want to send. You should have premade these and have them filed via your Sequential Mailer. If you did not pre-make messages, then you can choose from a premade Veretekk series of messages in text or HTML.

You then click UPLOAD LIST button. You can see a little flashing bar for a few seconds while it is uploading the list. When the flashing bar stops, you are done.

You can now click My EMAIL LISTS on left to see all your lists. Your new list will be in process pending mode for a short time before you can access it.

You can click My Email lists on left side to see your lists any time and all information about them anytime you need by clicking various text choices, or you can rearrange them. Like clicking on a list name will give you some info, then on that page clicking on STATISTICS tells you how many duplicates, how many opened your email, how many verified, and other info. Clicking on the number in a list row under # verified gives you info on the folks that verified to receive your messages with that list.

Just a note about duplicates;

When I have used Excel I used to get it filtered down to 0 duplicates out of the 10,000 leads. For some reason I usually end up with less than 10 duplicates using this software. Why? I think it has something to do with the first lead while going through the filtering and sorting process, so I sometimes delete the first lead after the filter sort process is complete and I am making my "10k" list to send.

Perhaps with more use and experimentation I will figure it out and get it down to 0. I can live with a few duplicates though.