|
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
-
Click
on File and then on Open...
-
In
the Look In: box go to the drive or the directory
on your hard drive that you saved the file to.
-
In
the Files of Type: box choose All Files.
-
Locate
your file and double click on it.
-
A
Text Import Wizard will appear.
-
Under
Choose the file type that best describes you data,
select Delimited and hit Next.
-
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.
-
Make
sure that the Text Delimiter is " and hit Next.
-
In
step 3, under Column Data Format select Text
and hit Finish.
-
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 Envelopes
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 |
|
|
|
|