Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Practice Management
VAT Filer
CloudConnect
Anti-Money Laundering
Support home
Video Training Guides
NEW

Hot Topics
SimpleStep Guides
Release Notes
Technical
Known Issues

Service Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Preparation
Agent Services Account
MTD for VAT
MTD for Income Tax
MTD for VAT
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

How to do mail merge in Linux versions of TaxCalc

Article ID: 2486
Last updated: 27 Sep, 2019
Note this article needs to cover creating the merge docs and merging them in Openoffice/LibreOffice

Mail Merge allows you to export client data into documents, including letters and forms. You can access Mail Merge via Practice Manager.

In Windows most of this is handled in Microsoft Word through automation.. In Linux there are manual elements involved in completing a mail merge. This article will guide you through creating a Mail Merge document on Ubuntu, while using Libreoffice. Other distributions and office programs may look slightly different but the basic process will be the same.

  1. Open TaxCalc
  2. Open Practice Manager from the home screen.
  3. Select Mail Merge from the left-hand menu. To start with you will see the standard filer (all clients) but you can create custom filters later.
  4. Select Create New Mail Merge, which opens the wizard. Click Continue. (If you have previously created the mail merge client list select
  5. Fill in the Name and Description fields for the Mail Merge. Click Continue.
  6. Select the tax year and one of All Clients, Specific clients or Advanced client selection (Data mine).
  7. Choose your clients and click Continue.
  8. Check that the summary of clients is correct and click Continue.
  9. Select a template from the list and click on Use Template.
  10. You are now shown the Window saying MS Word not found. You need to export the client data in a csv format (You will later merge the data and letter to create the finished documents/output).

Please Note: When saving the document make sure you put the file extension on the end of the filename, for example documentname.csv. If this is not done the merge will not work.

  1. click export data to save the csv file.
  2. Export the template you want to use
  3. Select the template.
  4. click export template
  5. save the template (the default is the user documents folder)
  6. Close the window that opens when you save it

  1. When you've made all relevant changes to the template, click Finish & Merge on the top toolbar of Word.
  2. Click OK.
  3. Your merged document should now appear on screen with merge details of your clients.

PLEASE NOTE: You can save a list of clients that you might use frequently by clicking on Finish & Save on the Finish screen.

Article ID: 2486
Last updated: 27 Sep, 2019
Revision: 5
Views: 86
This article was:  


Also listed in
folder Technical -> Linux