Address labels - SuiteCRM & LibreOffice 5.1

I have been looking for a way to create address labels (also know as mailing labels) since SuiteCRM does not provide a direct means for creating the labels. I now have a workflow that will create the labels.

  • No, this is not a simple 1 or 2 click workflow to print address labels.
  • Yes, this is a multi-step manual workflow.
  • Yes, it does create printable address labels.

My workflow is based upon the “Alternative to Mail Merge” posting by jshaheen on the SugarCRM Community Forum, January 25, 2016.

I offer this workflow “As Is” without any warranty. Please make a backup copy of your data before using the steps in this workflow. I have not experienced any data integrity issue with this workflow, but “Murphy’s Law” always applies.

Workflow Overview
This workflow has two major phases (Initial Setup and the Subsequent Updating & Reprinting) with several manual steps in each phase. It uses SuiteCRM as the data source, and LibreOffice 5.1 for the other workflow steps.

  • SuiteCRM, contact database, address label report, export as a csv file.
  • LibreOffice, import the csv file, and manipulate the data to create the printable labels.

I had problems using LibreOffice 4.2, so it would be best to use the latest version of LibreOffice. A similar workflow should be possible with Microsoft Office or OpenOffice.

The workflow details with screenshots are in the design section of the attached document.

Initial Setup

  • SuiteCRM, Create a custom data field in the Contact module to filter the data
  • SuiteCRM, Create and save your report, then export as a csv file
  • LibreOffice, Use Calculate, Base, and Writer to open the csv file and create and save the label template
  • LibreOffice, Writer, Print your labels
  • Your File Manger, Cleanup, Erase the working files (csv, ods and odb)

Subsequent Reports

  • SuiteCRM, update your data and run the report, then export as a csv file
  • LibreOffice, Calculate & Base, open the csv file, save ods file, save odb file
  • LibreOffice, Writer, Open the existing label template file and print your labels
  • Cleanup working files

1 Like

Great work. Thanks for the SOP!