Contact management > Keeping in touch with your contacts > Personalized letters
You can create personalized letters (also known as mail-merge letters) for any of your contacts. A personalized 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.
Personalized 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 the contact’s name, address, and the amount owing.
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 software’s program folder.
List of templates provided with your software
apologize for a problem your company has caused for a customer, and to assure the customer that the problem will be addressed.
let your customers know that items they’ve ordered are on backorder and will be shipped as soon as possible.
remind customers whose accounts have become overdue to make a payment.
express greater urgency than the first collection letter and request that your customer contact you immediately.
urge customers who have overdue payments to make a payment before their credit history is damaged.
advise customers that you will turn their account over to a collection agency if payment isn’t made within a specified number of days.
advise customers that you will turn their account over to a collection agency if payment isn’t made within a specified number of days.
advise customers that you have turned their overdue payment over to a collection agency who will be getting in touch with them.
Complaint Resolution
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.
provide a standard credit application form to customers, with a section detailing your credit terms.
thank new customers for their business and offer a discount on future purchases for a limited time.
To print personalized letters using Microsoft Word
Display the A/R (Accounts Receivable) tab of the To Do List window and click the Action column for each customer to whom you want to send a letter. Click Mail Merge to select a collection letter template, which includes information such as the customer’s outstanding balance.
1
Go to the Card File command centre and click Create Personalized 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 personalized letter.
You can filter your contact list 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.
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.
To print a personalized letter for a single contact using Microsoft Word
1
Go to the Card File command centre and click Cards List. The Cards List window appears.
2
Select a card and click Edit. The Card Information window appears.
3
Click the Action menu and choose Create Letter.Click Letter. The Select from List window appears.
4
Select the letter template you want to use and click Use Template. Your letter appears in Word, and depending on the template you have selected, you will be prompted to enter additional information, such as your name and title.
To modify a Microsoft Word template
2
Go to the File menu and choose Open. The Open window appears.
4
From the Files of Type field, select All Files.
5
6
Go to the Tools menu and choose Options. The Options window appears.
7
Click the View tab. Select the Field Codes option and then click OK.
The template includes OfficeLink field codes, formatted as text surrounded by double brackets, for example, [[Name]]. These fields will automatically be filled with your contact’s details when the letter is printed.
Some templates require you to enter your name and title each time you use them. If you don’t want to enter these details, replace the following fields { FILLIN “Enter your Name:”\o } and { FILLIN “Enter your title:”\o } with your name and title at the bottom of the letter.
8
Edit the template and then go to the File menu and choose Save.
To print a personalized letter using other word processors
If you want to use a mail-merge letter template created using word processors other than Microsoft Word, you will need to export the 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 Personalized Letters. The Review Cards Before Exporting window appears.
You can filter your contact list to show contacts who are located within specific postcodes by clicking Advanced filters and entering your 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.
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.
7
Use your word processing software to merge the data contained within the text file with a letter template that you have created.

Click to show more information

Top of page