---
title: "Configuring the Letter Data Source"
slug: "configuring-the-letter-data-source"
updated: 2024-10-31T11:53:36Z
published: 2024-10-31T11:53:36Z
canonical: "docs.interprose.com/configuring-the-letter-data-source"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Configuring the Letter Data Source

This guide provides a comprehensive walkthrough for configuring the Letter Data Source in LibreOffice, the initial step before creating letters with ACE. Follow these steps:

### Step 1: Install LibreOffice

LibreOffice, an open-source (free) application equipped with a text editor, serves as the supported platform for modifying your ACE letter and invoice templates.

- Download and install [LibreOffice](https://www.libreoffice.org/) from the official website.

### Step 2: Download and Register ACE’s Letter Data Source

The “Letter Data Source” is a specific spreadsheet obtained by downloading it from ACE through the **Help → Layout →Letter Data** **Source** menu. This spreadsheet comprises tables and fields. In the context of letter creation using LibreOffice, these fields act as placeholders, allowing users to dynamically insert information from ACE into their documents.

1. Open any account in ACE to download the letter data source; opening an account with relevant data allows for testing and template validation, helping identify and select desired fields.
2. Navigate to **Help → Layout → Letter Data Source**.
3. In the sidebar, click on "Download Letter Data Source."
  1. Save the downloaded file (default name: ACE.ods) to your computer, noting its location.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/Screenshot 2024-01-22 094242.png?sv=2026-02-06&spr=https&st=2026-10-31T15%3A34%3A56Z&se=2026-10-31T16%3A34%3A56Z&sr=c&sp=r&sig=oMjxHlNS6ztmH7jy%2BES1xdB%2FGSy1Y7HHWsD%2BV6SjfHk%3D)

Image Displays Menu Navigation in Step 2

### Step 3: Register the Database

1. Open LibreOffice:
  1. **File → New →Database**
2. A Database Wizard will popup:
  1. Choose “Select Database” on the left section.
  2. Choose “Connect to an existing database” and select “Spreadsheet” from the dropdown.
3. Follow the prompts:
  1. Next → Browse (select ACE.ods) → Next → Finish.
  2. Change the file name to "ACE.ods" and remember its location.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/register letter data source(1).gif?sv=2026-02-06&spr=https&st=2026-10-31T15%3A34%3A56Z&se=2026-10-31T16%3A34%3A56Z&sr=c&sp=r&sig=oMjxHlNS6ztmH7jy%2BES1xdB%2FGSy1Y7HHWsD%2BV6SjfHk%3D)

GIF Demonstrates Step 3

### Step 4: Finalize the Process

When finished, go to File → Exit to conclude your session.

### Step 5: Keep the Database for Future Use

Remember to keep the ACE.odb database for future letter editing. Repeat the registration process for each computer used for letter editing.

### Step 6: Update Letter Database

- Each time you add new Forms to your ACE system, download the letter database again.
- Each time a new field is available, download the letter database again.
- Save it in the same location with the same name ("ACE.ods").
- Confirm overwriting if prompted to maintain the connection with the ACE.odb database.

> [!NOTE]
> Tip: Organize with an ACE Letters Folder
> 
> Enhance your workflow by creating a dedicated ACE Letters folder on your computer. This folder is ideal for storing both the ACE.ods database and your ACE letters. By centralizing these files, you ensure easy access and efficient management. Simply set up the folder in a location of your choice, and maintain a well-organized repository for all your ACE-related documents.

The "Letter Data Source" is a specific spreadsheet that can be downloaded from ACE via **Help → Layout → Letter Data Source**. This spreadsheet contains tables and fields that act as placeholders for dynamically inserting information from ACE into LibreOffice documents, text messages, and emails.

a free, open source office suite of applications; ACE local print and ELS (Electronic Letter Service) email letter templates are written using the LibreOffice Writer word processor

provide the ability to import account data or client data without a native home in ACE.

Forms are flexible in the following ways:

- Debt forms can be included on the account page or can stand alone from the account sidebar on the left
- Debt forms that are standalone may be single instance or multi-instance
- Client forms can be included on the client profile page

Please reach out to support if you have questions about form customization or transaction forms.