Help and Information Centre - GA2

Article: Article:

Using GA2 / GA3 and MS Word for MailMerge / Labels

Back Print

The following is a basic set of instructions to help you create a Mail Merge using your data from Garage Assistant together with Microsoft Word.

Mailmerges allow you to insert address data onto Labels or Custom Letters...

First you will need to export your customers, for this go to Customers  then click on export for mail merge. (at the top under the buttons).

In the latest release you can go into the customer address book and export for mail merge.
You can also go into Mailings, Custom Mailing and again, Export Selected Names and Addresses

In MS word you can then go to:

  • Tools
  • Letters and Mailings 
  • Mail Merge

 

  1. Choose "Labels" from the right hand side. then Next: Starting document
  2. Choose your label options i.e Avery label sizes, then choose Next : Select Recipients
  3. Leave use an existing list checked and click browse. 
  4. Locate the exported file in c:\GAEXPORTS 
  5. It will be names "Mail_Merge_List.xls, then choose ok on the select table screen and again ok on the Mail Merge Recipients screen. 
  6. Click Next: Arrange your labels 
  7. Then click "Address Block" when that window pops up choose "Match Fields" in the lower left. 

 

  • Match up the available fields, such as
  • Surname -> Mail Merge Full Name
  • Address 1 -> Mail Merge Road Name
  • Address 2 -> Mail Merge Locality
  • and so on...

 

  1. Next Click "ok" on both popup windows and you should see <> inserted on the first label.
  2. Choose Update All Labels to apply this to all labels.
  3. Click on Next: Preview your labels then Next: Complete the merge
  4. Click on Print......

Print Back to other articles