About our Company
Our Product information
Mailing lists we sell
Our services
Upgrades and updates
Purchase our lists or software
Contact us
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Site Search

 
Once you have your data extracted(or if you purchased our Business CD) you need a way to utilize it. All extractions may be easily imported into Excel for further manipulation. Most any database program will accept the common format that Contact Spyder uses. (CSV format). See a sample of extracted data. Below are some of the best ways we have found to work with your new lists.


Importing into Microsoft Excel
  1. Click on File and then on Open...
  2. In the Look In: box go to the drive or the directory on your hard drive that you saved the file to.
  3. In the Files of Type: box choose All Files.
  4. Locate your file and double click on it.
  5. A Text Import Wizard will appear.
  6. Under Choose the file type that best describes you data, select Delimited and hit Next.
  7. In step 2, under Delimiters, you will want to put a check mark in the box that says Comma and take the check mark out of Tab.
  8. Make sure that the Text Delimiter is " and hit Next.
  9. In step 3, under Column Data Format select Text and hit Finish.
  10. You will now see the data you downloaded in the spreadsheet.


Importing into Microsoft Word 6.0, 7.0, 97 & 2000 Mail Merge Format For Labels

Open a new document.
From the Tools menu, select Mail Merge.
Click on Create, then choose Mailing Labels.
In the pop-up menu, select Active Window.
Click on Get Data, then choose Open Data Source.
In the Look In: box go to the directory on your hard drive that you saved the file to.
In the Files of Type: box, select All Files. Locate your file and double click on it.
You may or may not get a window that says Confirm Data Source. If you receive this message select Text Files (*.txt). Hit OK.
Word 2000 users: At the File Conversion window, select Plain Text, then click OK.
Choose the Set Up Main Document button.
Choose the address label type under Product Number, then click OK.
Click on Insert Merge Field, then click on Contact Name, press the Enter key.
Click on Insert Merge Field, then click on Company, press the Enter key.
Click on Insert Merge Field, then click on Address, press the Enter key.
Click on Insert Merge Field, then click on City, type a comma and a space.
Click on Insert Merge Field, then click on State, press the spacebar twice.
Click on Insert Merge Field, then click on Zip, then click OK.
If you're ready to print labels now, make sure the printer is loaded with blank labels. Click the Merge button.
In the Merge To: box, select Printer.
If you're going to print all the labels now, make sure All is selected in the Records To Be Merged: box; otherwise, in the From and To boxes, enter the appropriate numbers (Example: if you're printing labels 20 to 200, in the From box enter 20, and the To box enter 200).
Click the Merge button.
In the Print dialog box, click on OK.
To save your work, click on File and select Save.
Your labels have been printed!




Importing into Microsoft Word 6.0, 7.0, 97 & 2000 Mail Merge Format For Envelope
s
Start Microsoft Word.
From the Tools menu, select Mail Merge.
Click on Create, and select Envelopes.
Click on Active Window.
Click on Get Data, and select Open Data Source.
In the Look In: box go to the directory on your hard drive that you saved the file to.
In the Files of Type: box select All Files. Locate your file and double click on it.
You may or may not get a window that says Confirm Data Source. If you receive this message select Text Files (*.txt). Hit OK.
Word 2000 users: At the File Conversion window, select Plain Text, then click OK.
Click on Set Up Main Document to insert your merge fields.
In the Envelope Options window, select the appropriate envelope size and hit OK.
Click on Insert Merge Field, then click on Contact Name, press the Enter key.
Click on Insert Merge Field, then click on Company, press the Enter key.
Click on Insert Merge Field, then click on Address, press the Enter key.
Click on Insert Merge Field, then click on City, type a comma and a space.
Click on Insert Merge Field, then click on State, press the spacebar twice.
Click on Insert Merge Field, then click on Zip, then click OK.
If you're ready to print envelopes now, make sure the printer is loaded. Click the Merge button.
In the Merge To: box, select Printer.
If you're going to print all the envelopes now, make sure All is selected in the Records To Be Merged: box; otherwise, in the From and To boxes, enter the appropriate numbers (Example: if you're printing letters 20 to 200, in the From box enter 20, and the To box enter 200).
Click the Merge button.
In the Print dialog box, click on OK.
To save your work, click on File and select Save.
Your envelopes have been printed!



Importing into Microsoft Office 2003
+(Word,Excel and Outlook)
Click here for full instructions using Office 2003 - Present