Mail merge

src: www.outlook-apps.com

Mail merge is a process to create personalise letters and pre-addressed envelopes or mailing labels for mass mailings from a form letter. The feature is usually employed in a word processing document which contains fixed text (which is the same in each output document) and variables (which act as placeholders that are replaced by text from the data source). The feature dates back to early word processors on personal computers, circa 1980. WordStar was perhaps the earliest to provide this, originally via an ancillary program called Mail merge. WordPerfect also offered this capacity for CP/M and MS-DOS systems, and Microsoft Word added it later on.

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 process is run, the word processing system creates an output document for each row in the database, using the fixed text exactly as it appears.

Mail merge to create a form letter which you intended to print or e-mail multiple times sending each copy to different recipient, you can insert field, such as name or address, which word will replace automatically with information form a database or contact list for each copy of the form letter

Video Mail merge

Overview

The mail merging process generally requires the following steps:

1. Creating a Main Document/Template.
2. Creating a Data Source.
3. Defining the Merge Fields in the main document.
4. Merging the Data with the main document.
5. Saving/Exporting.

A common usage is for creating "personalized" letters, where a template is created, with a field for "Given Name", for example. The templated letter says "Dear <Given Name>", and when executed, the mail merge creates a letter for each record in the database, so it appears the letter is more personal. It is often used for variable data printing. It can also be used to create address labels from a customer relationship management database, or for mass emails with pertinent information in them, perhaps a username and password.

Maps Mail merge

See also

• Desktop publishing
• Digital printing
• Dynamic publishing
• Mass customization
• Word processors

src: i.ytimg.com

References

src: www2.eecs.berkeley.edu

External links

• Mail merge with Openoffice.org
• Mail merge with Microsoft Word
• Video tutorial on how to Mail merge using Microsoft Excel and Word
• Video demo on how to data/mail merge using a 3rd party tool

Source of the article : Wikipedia