|
| CRS - How to Export Records directly to MS Excel Spreadsheet |
|
HOWTO NOTE Must have Microsoft Office 2000 or higher 1. Search for the records you want to export. NOTE You do not need to mark the records if you want to export all the records in your search. See below if you only want to export marked records. 2. Click the Export/Labels button. 3. The Options for Exporting Records/Printing Labels page will open.
Enter the Number of Records you want to export. Number cannot be more than 300, the default is 30 records.
4. You have the option to Skip records with no zip code and to Remove exact duplicates. Put a check mark in the desired boxes. 5. For Addressee Is Displayed As: select one of the options
6. For Address Used Is: select the option you are most interested in.
7. For When Exporting to Comma delimited Files: You have the option to Include additional fields for Mr/Mrs., First, Middle, & Last Names. Check the box if you would like to export these fields. 8. For Export File select MS Excel SpreadSheet 9. Click the Export button (green button) 10. MS Excel will open with the data fields separated in columns. Click File then Save As 11. In the Save As window select the location to save
the file. Change the Save as type to Microsoft Excel Workbook (*.xls). Enter a filename and click Save.
How to Export Records How to Export Marked Records How to Export more than 300 Records | |
| Copyright © 2003, Courthouse Retrieval System, Inc., All Rights Reserved. |