<< Return to help center
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
This article has been updated for the latest version of Less Annoying CRM. If your CRM looks different, you can click here to upgrade to the newest version of LACRM!

Preparing for a mail merge

A mail merge is the automation of adding data (like names and addresses) to mailing materials (letters and envelopes). In order to run your mail merge, you'll need to use at least 2 programs: one for spreadsheets and another for creating your mailing materials. Here's how to prep your data and run a mail merge from LACRM:

Export your data.
  • You can export your data from Less Annoying CRM for use in your mail merges. Learn how to export a specific group of contacts here.
Prepare your data.
  • Delete the columns that don't include the data you want, for example you may not need phone numbers or background info included in your letters, envelopes, or labels.
Prepare your mailing materials.
  • Create template documents, labels, and envelopes in a word processing program like Microsoft Word.
Merge your data with your mailing materials.
  • Using Microsoft: If you plan on creating your mail-merge documents in Word and Excel, you can follow this tutorial from Microsoft.
  • Using Google: Google Docs and Sheets don't have a built-in mail-merging feature, but you can purchase a plugin (like this one) to help you merge your data. There are also plugins that work with Google Sheets and Gmail (like this one) to help you run an email merge; instead of creating documents and labels that you can print, you can send personalized emails.
  • Please note: this article contains links that go out to other sites not maintained by Less Annoying CRM, so they may change or go away without us knowing. If you find an erroneous or dead link here, just give us a shout and we'll get you pointed in the right direction.
Next up:
Keywords:
Mail merge, labels, addresses
How do I can you are you able to can I how to is it possible