Exporting contact list to excel
Click on the Contacts toolbar icon.
The list presents basic details of every contact in your database.
A Dark Green background means that you have selected the contact.
You may select contacts in a continuous group by clicking on the first contact in the group, holding down the Shift key and then clicking on the last contact in the group.
Individual contacts may be selected or deselected by holding down the Ctrl key and clicking on the contact.
Click on the Select All button, to select all contacts.
Step 2. Mail Merge
Click on Mail Merge button at the bottom of the page
Step 3. Error Message - Click Yes
Click Yes to the following message:
You will need to remember or make a note of the location that the file is being saved to.
Click OK to the Information message: 'Done.'
You can now open in Excel.
Step 4. Open Microsoft Excel
In the Text Import Wizard - Step 1 of 3 window:
Click on the Delimited radio dial to select.
Click on the Next button.
In the Text Import Wizard - Step 2 of 3 window:
Tick the Comma Delimiters option check box.
Select " as the Text qualifier from the drop down list.
Click Next button.
In the Text Import Wizard - Step 3 of 3 window:
General is the default Column data format.
Click on the Finish button.
Select where you want to put the data e.g. Existing worksheet, if Excel is opened on empty worksheet.
Click on the OK button.
Your Excel worksheet should look similar to the following:
Article ID 493
Related Articles
Exporting Contacts to CSV File
Exporting Contacts to CSV File Exporting my Contacts list in Stockbook, to a CSV (comma-separated-variable) file, for use in a mail-merge or spreadsheet. Step 1. Contact Click on the Contacts toolbar icon Step 2. Select Contacts Select all Contacts ...
Contacts: Last Contact Date
Contacts: Last Contact Date Used for recording a date when contact was made in Stockbook Step 1. Open Contacts to Edit Open the Contacts Screen Select the Contact that you wish to record the date of contact on from the contact list in Stockbook by: ...
Exporting Weights to Breedplan
Exporting weights to Breedplan Step 1. Animals can be either: selected on the basis of any animal whose performance data matches the entered criteria e.g. weight type, date range. (see Step 3), or preselected on the main animal list (see below) Click ...
Print mailing labels from my contacts list?
Labels can be printed using the Contact List in Stockbook: Step 1. Open your Contacts Click on the Contacts button Step 2. Select Contacts Highlight the contacts you want to print mailing labels for The list can be filtered by Contact Type When you ...
Exporting data to other systems
Stockbook provides you with an easy method of creating a master .CSV (comma-separated variable) file, containing selected information, for easy transfer to other equipment or loading into other software. Step 1. Select Animals If you Do Not wish to ...