Personalised letters

Contact management > Keeping in touch with your contacts > Personalised letters

You can create personalised letters (also known as mail-merge letters) for any of your contacts. A personalised letter is a document template that contains standard text as well as fields that can be automatically filled with data stored in your company file.

Personalised letters are useful when you need to send the same letter to several contacts. For example, you may want to send several slow-paying customers a payment reminder letter. Instead of entering each contact’s information on the letters yourself, you can set up a letter template that contains the text you want to appear, and insert data fields that automatically fill in with the contact’s name, address and the amount owing.

Printing personalised letters using Microsoft Word and OfficeLink

OfficeLink is a feature that automates the process of merging contact information stored in your company file with a Microsoft Word template (a .dot file). Your software includes a set of templates that you can use, and they are stored in the Letters folder, which is located within your AccountRight software’s program folder.

List of templates provided with your software:


Use this template...	When you want to...
Apology.dot	apologise for a problem your company has caused for a customer, and to assure the customer that the problem will be addressed.
Backordr.dot	let your customers know that items they’ve ordered are on backorder and will be shipped as soon as possible.
Blank.dot	write your own letter.
BounceCk.dot	notify customers whose payments have bounced.
Coll_1st.dot	remind customers whose accounts have become overdue to make a payment.
Coll_2nd.dot	express greater urgency than Coll_1st.dot and request that your customer contact you immediately.
Coll_3rd.dot	encourage customers who have overdue payments to make a payment before their credit history is damaged.
Coll_fin.dot	advise customers that you will turn their account over to a collection agency if payment isn’t made within a specified number of days.
Collection - Final Option 2.dot	advise customers that you will turn their account over to a collection agency if payment isn’t made within a specified number of days.
Collection - Sent to Agency.dot	advise customers that you have turned their overdue payment over to a collection agency who will be getting in touch with them.
Credit Application.dot	provide a credit application form to your customers.
FaxCover.dot	create a fax cover page. This page includes room for a memo.
Resolved.dot	reply to customers who have questioned an amount on their monthly statement. This letter indicates that you are looking into the matter and that you will credit the customer’s account for the amount in question while the matter is investigated.
ThankYou.dot	thank new customers for their business.
Thank You Offer Letter.dot	thank new customers for their business and offer a discount on future purchases for a limited time.

You can edit these templates and create new ones using the mail-merge features of Microsoft Word. For information about working with mail-merge templates, see Microsoft Word Help.

To print a personalised letter using Microsoft Word

1	Go to the Card File command centre and click Create Personalised Letters. The Review Cards Before Exporting window appears.

2	Click in the select column next to each contact to whom you would like to send a personalised letter.

tip : Filter your contacts

You can filter your contact list, for example, to only show contacts who are located within specific postcodes, by clicking Advanced filters and entering your criteria.

3	Click Mail Merge. The Select from List window appears.

4	Select the template you would like to use and then click Use Template.

Your letter appears in Microsoft Word, and depending on the template you have selected, you will be prompted to enter additional information, such as your name and title.

5	Edit the letters as required and then print them using Microsoft Word.

To print a personalised letter using other word processors

To use a mail-merge letter template created in a word processor other than Microsoft Word, you export the contact data out of your company file and then merge that data with the letter.

1	Go to the Card File command centre and click Create Personalised Letters. The Review Cards Before Exporting window appears.

2	Select the contacts to whom you would like to send a personalised letter.

tip : Filter your contacts

You can filter your contact list, for example, to only show contacts located within specific postcodes. To do this, click Advanced filters and enter your filtering criteria.

3	Click Disk. A window with a list of file formats appears.

4	Choose either the Tab-Delimited Text File or Comma-Separated Text File option.

note : Check what file formats your word processing software requires

Most word processing software allows mail-merge data to be tab-delimited (data is separated by tabs) or comma-separated. If your software requires a specific format, choose that format at this step.

5	Click Save. The Save As window appears.

6	If necessary, change the text file’s name and location and then click Save.

The text file containing your contacts’ details is saved at the location you specified.

7	Use your word processing software to merge the data contained within the text file with a letter template that you have created.