Info-Castle

WORKING WITH YOUR DATA

Once you have your data downloaded or if you purchased our CD, you need a way to utilize the data. All data can be easily imported into Excel for further manipulation. All of the widely used database programs will accept the common format that we uses (.CSV format).

 Below are some of the best ways we have found to work with your new lists.

Importing into Microsoft Excel

Once in 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.
hit Next.
In step 3, under Column Data Format select Text and hit Finish.
The data you downloaded will open 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!

Still didn’t find an answer to you question? Contact us we will be glad to help