Exporting contact list to excel

Exporting contact list to excel

Step 1. Contacts 

Click on the Contacts toolbar icon.

The list presents basic details of every contact in your database.
  1. A Dark Green  background means that you have selected the contact.
  2. 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.
  3. Individual contacts may be selected or deselected by holding down the Ctrl key and clicking on the contact.
  4. 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.

  1. Click  OK  to the Information message: 'Done.'
  2. You can now open in Excel.

Step 4. Open Microsoft Excel

  • Open your Microsoft Excel program.
  • Click on the Data tab.
  • Double click on From Text.

 

  • Select the Mail Merge file created earlier.
  • Click on the Import button.

In the Text Import Wizard - Step 1 of 3 window:
  1. Click on the Delimited radio dial to select.
  2. Click on the Next button.

 

In the Text Import Wizard - Step 2 of 3 window:
  1. Tick the Comma Delimiters option check box.
  2. Select " as the Text qualifier from the drop down list.
  3. Click Next button.

 

In the Text Import Wizard - Step 3 of 3 window:
  1. General is the default Column data format.
  2. Click on the Finish button.


  1. Select where you want to put the data  e.g. Existing worksheet, if Excel is opened on empty worksheet.
  2. 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 ...