Cristallight Software Logo image

What is mail merge?

Mail Merge is a process of creating personalized letters, pre-addressed envelopes, or address labels from the so called form letter, which is a document consisting of fixed contents same for each output document, and placeholders for variable text, that make each copy of the document unique. This unique information for the placeholders is taken from a data source.

The data source is typically a spreadsheet or a database which has a field or column for each variable in the template. When the mail merge is run, the software system creates an output document for each row in the database, using the fixed text exactly as it appears in the template, but substituting the data variable placeholders in the template with the values from the matching columns.

The Mail merge process can be split to several simple stages. The steps of mail merge are:

  1. Create the main document with the fixed contents you need,
  2. Choose an existing Data Source, or create a new one,
  3. Add the merge field placeholders into the main document taking into account that when you perform the mail merge, the mail merge fields become filled with information from your data file. Since the information can be of different size, make sure the placeholders are big enough to contain the most lengthy one, and set the desired alignment, anchorage, etc. of the placeholder.
  4. Merge the data with the main document, and preview the result. If possible, preview each copy of the document before you print the whole set.

The advantages of mail merge is that the feature saves your time and efforts. Producing mass mailings is much simplified, especially compared to the process of preparing individual letters or envelopes to many people.
The mail merge feature on mac is supported by several software titles, the Labels and Databases among them.
The power and flexibility of mail merge systems varies considerably from one software product to another.

Mail merge also is often called print merge.

iBarcoder Box icon

Price: $49.95    Version: 3.9.7

iBarcoder - easy to use mac barcode generator and label maker software.It is professional barcode maker for creating any number of individual, or sequential barcodes, printing them as colorful barcode labels in your own style, of any size, or shape, or exporting them as graphic image files in common vector and raster image formats. No need to spend money for purchasing costly barcode stickers for your business!

LabelsAndDatabases icon

Price: $24.99    Version: 1.6.1

Labels and Databases - advanced mac labels design software with comprehensive sql database support. It helps you to create labels, envelopes, and cards using various built-in label formats, and fill them with the information contained in user databases, that is create and print labels by using Mail Merge. Various objects, like text, graphics and images, boxes, ovals, lines, patterns in any font, color or rotation, gradient fills, database field objects, barcodes can be easily added to your documents.

Copyright © Cristallight Software. 2004-2020. All Right Reserved