Are you an EPFL student looking for a semester project?
Work with us on data science and visualisation projects, and deploy your project as an app on top of Graph Search.
Concept
Mail merge
Summary
Mail merge consists of combining mail and letters and pre-addressed envelopes or mailing labels for mass mailings from a form letter.
This 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 word to word).
Some word processors can insert content from a database, spreadsheet, or table into text documents.
It is a powerful tool for writing a personalized letter or e-mail to many people at the same time. It imports data from another source such as a spreadsheet and then uses that to replace placeholders throughout the message with the relevant information for each individual that is being messaged.
Mail merge 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; Microsoft Word added it later on,
as did Multimate.
Money can be saved by pre-sorting on zip code and grouping by postal-discount requirements (same ZIP code, same SCF).
A paperless approach is to use mail merge to format email.
Going beyond words, in 2018 The New York Times detailed a further instance of "mass customization" - personalized videos.
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.
The mail merging process generally requires the following steps:
Creating a main document and the template.
Creating a data source.
Defining the merge fields in the main document.
Merging the data with the main document.
Saving/exporting.
A common usage is for creating "personalized" letters, where a template is created, with a field for "Given Name", for example.
Official source
About this result
This page is automatically generated and may contain information that is not correct, complete, up-to-date, or relevant to your search query. The same applies to every other page on this website. Please make sure to verify the information with EPFL's official sources.