Mail merge

Last updated

Mail merge consists of combining mail and letters and pre-addressed envelopes or mailing labels for mass mailings from a form letter. [1]

Contents

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. [2] [3]

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.

History

Mail merge dates back to early word processors on personal computers, circa 1980. [4] WordStar [4] [5] was perhaps [6] the earliest to provide this, [7] originally via an ancillary program called Mail merge. WordPerfect also offered this capacity for CP/M and MS-DOS systems; [8] Microsoft Word added it later on, [9] as did Multimate. [10] [11] [12] [13] [14]

Advanced features

Money can be saved by pre-sorting on zip code and grouping by postal-discount requirements (same ZIP code, same SCF). [ citation needed ]

A paperless approach is to use mail merge to format email. [15]

Going beyond words, in 2018 The New York Times detailed a further instance of "mass customization" - personalized videos. [16] [ relevant? ]

Overview

The data source is typically a table in a document, or a spreadsheet or database which has a field or column for each variable in the template. When the word processor's mail merge is run it creates an output document for each row in the data source, using the fixed text from the data source.

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 template.
  4. Merging the data source with the main document template.
  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.

See also

Related Research Articles

<span class="mw-page-title-main">Microsoft Word</span> Word processor

Microsoft Word is a word processor program developed by Microsoft. It was first released on October 25, 1983, under the name Multi-Tool Word for Xenix systems. Subsequent versions were later written for several other platforms including: IBM PCs running DOS (1983), Apple Macintosh running the Classic Mac OS (1985), AT&T UNIX PC (1985), Atari ST (1988), OS/2 (1989), Microsoft Windows (1989), SCO Unix (1990), macOS (2001), Web browsers (2010), iOS (2014) and Android (2015).

MultiMate was a word processor developed by Multimate International for IBM PC MS-DOS computers in the early 1980s.

<span class="mw-page-title-main">Word processor (electronic device)</span> Electronic device

A word processor is an electronic device for text, composing, editing, formatting, and printing.

<span class="mw-page-title-main">WordPerfect</span> Word processing application

WordPerfect (WP) is a word processing application, now owned by Alludo, with a long history on multiple personal computer platforms. At the height of its popularity in the 1980s and early 1990s, it was the market leader of word processors, displacing the prior market leader WordStar.

<span class="mw-page-title-main">WordStar</span> Word processor application

WordStar is a discontinued word processor application for microcomputers. It was published by MicroPro International and originally written for the CP/M-80 operating system, with later editions added for MS-DOS and other 16-bit PC OSes. Rob Barnaby was the sole author of the early versions of the program.

Lotus Symphony was an integrated software package for creating and editing text, spreadsheets, charts and other documents on the MS-DOS operating systems. It was released by Lotus Development as a follow-on to its popular spreadsheet program, Lotus 1-2-3, and was produced from 1984 to 1992. Lotus Jazz on the Apple Macintosh was a sibling product.

<span class="mw-page-title-main">Autocomplete</span> Computing feature predicting ending to a word a user is typing

Autocomplete, or word completion, is a feature in which an application predicts the rest of a word a user is typing. In Android and iOS smartphones, this is called predictive text. In graphical user interfaces, users can typically press the tab key to accept a suggestion or the down arrow key to accept one of several.

<span class="mw-page-title-main">NeoOffice</span> macOS office suite

NeoOffice was an office suite for the macOS operating system developed by Planamesa Inc. It was a commercial fork of the free and open source LibreOffice office suite, including a word processor, spreadsheet, presentation program, and graphics program. It added some features not present in the macOS versions of LibreOffice and Apache OpenOffice. The last few versions were based on LibreOffice 4.4, which was released mid-2014.

<span class="mw-page-title-main">Pages (word processor)</span> Word processor developed by Apple Inc.

Pages is a word processor developed by Apple Inc. It is part of the iWork productivity suite and runs on the macOS, iPadOS, and iOS operating systems. It is also available on iCloud on the web. The first version of Pages was released in February 2005. Pages is marketed by Apple as an easy-to-use application that allows users to quickly create documents on their devices. Many Apple-designed templates comprising different themes are included with Pages.

<span class="mw-page-title-main">Database publishing</span> Automated Media Production

Database publishing is an area of automated media production in which specialized techniques are used to generate paginated documents from source data residing in traditional databases. Common examples are mail order catalogues, direct marketing, report generation, price lists and telephone directories. The database content can be in the form of text and pictures but can also contain metadata related to formatting and special rules that may apply to the document generation process. Database publishing can be incorporated into larger workflows as a component, where documents are created, approved, revised and released.

<span class="mw-page-title-main">Epson QX-10</span>

The Epson QX-10 is a microcomputer running CP/M or TPM-III which was introduced in 1983. It was based on a Zilog Z80 microprocessor, running at 4 MHz, provided up to 256 KB of RAM organized in four switchable banks, and included a separate graphics processor chip (μPD7220) manufactured by NEC to provide advanced graphics capabilities. In the USA and Canada, two versions were launched; a basic CP/M configuration with 64 KB RAM and the HASCI configuration with 256 KB RAM and the special HASCI keyboard to be used with the bundled application suite, called Valdocs. TPM-III was used for Valdocs and some copy protected programs like Logo Professor. The European and Japanese versions were CP/M configurations with 256 KB RAM and a graphical BASIC interpreter.

Variable data printing (VDP) is a form of digital printing, including on-demand printing, in which elements such as text, graphics and images may be changed from one printed piece to the next, without stopping or slowing down the printing process and using information from a database or external file. For example, a set of personalized letters, each with the same basic layout, can be printed with a different name and address on each letter. Variable data printing is mainly used for direct marketing, customer relationship management, advertising, invoicing and applying addressing on selfmailers, brochures or postcard campaigns.

<span class="mw-page-title-main">Microsoft Office 2007</span> Version of Microsoft Office

Microsoft Office 2007 is an office suite for Windows, developed and published by Microsoft. It was officially revealed on March 9, 2006 and was the 12th version of Microsoft Office. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007. The Mac OS X equivalent, Microsoft Office 2008 for Mac, was released on January 15, 2008.

<span class="mw-page-title-main">Microsoft Office 2001</span> Suite of productivity software by Microsoft

Microsoft Office 2001 is a suite of productivity software for Mac OS 8, Mac OS 9, or the Classic environment in Mac OS X. It is the Mac equivalent of Office 2000. It was developed by Microsoft and announced on September 13, 2000 before its release on October 11, 2000.

The term template, when used in the context of word processing software, refers to a sample document that has already some details in place; those can either by hand or through an automated iterative process, such as with a software assistant. Once the template is completed, the user can edit, save and manage the result as an ordinary word processing document. Word processing templates enable the ability to bypass the initial setup and configuration time necessary to create standardized documents such as a resume. They also enable the automatic configuration of the user interface of the word processing software, with features such as autocompletion, toolbars, thesaurus, and spelling options.

<span class="mw-page-title-main">MicroPro International</span> American software company (1978–1993)

MicroPro International Corporation was an American software company founded in 1978 in San Rafael, California. They are best known as the publisher of WordStar, a popular early word processor for personal computers.

Template may refer to:

Productivity software is application software used for producing information. Its names arose from it increasing productivity, especially of individual office workers, from typists to knowledge workers, although its scope is now wider than that. Office suites, which brought word processing, spreadsheet, and relational database programs to the desktop in the 1980s, are the core example of productivity software. They revolutionized the office with the magnitude of the productivity increase they brought as compared with the pre-1980s office environments of typewriters, paper filing, and handwritten lists and ledgers. In the United States, some 78% of "middle-skill" occupations now require the use of productivity software. In the 2010s, productivity software had become even more consumerized than it already was, as computing became ever more integrated into daily personal life.

References

  1. ↑ "Cambridge Dictionary Online" . Retrieved 14 May 2016.
  2. ↑ "Frequently asked questions about the mail merge feature in Word". the result is that each row (or record) in the data source ... listed in a spreadsheet ...
  3. ↑ "Mail Merge". iSchool.uTexas.edu (Tutorials). Archived from the original on 2013-01-27. Retrieved 2018-11-02.
  4. 1 2 see p. 2-2; MailMerge not a new feature, and this is 2nd Ed, (C) 1982 "WordStar Training Guide (2ed Feb83) (C) 1982" (PDF). TRADEMARKS ... MailMerge
  5. ↑ "M Run Mail Merge. S Run SpellStar"
  6. ↑ WinWorldPC citation says "the first"
  7. ↑ "Software Spotlight: WordStar". WinWorld PC. WordStar was the first microcomputer word processor to offer mail merge
  8. ↑ "I Love WordPerfect Contest". I was introduced to Wordperfect DOS when I bought my first computer in college. ... I have watched WordPerfect evolve from the ancient MS-DOS ...
  9. ↑ "WordStar MailMerge". 29 April 1986. Retrieved 20 May 2016.
  10. ↑ "Early" magazine articles about Multimate's Mail Merge were largely 1988-1990"
  11. ↑ "dBase, MultiMate: Mailmerge". PC Magazine. February 29, 1988. p. 222. ... a must for dBASE users who need to mailmerge ... MultiMate Advantage II's mail-merge capabilities work nicely with dBASE.
  12. ↑ "Multimate Mail Merge". InfoWorld. January 23, 1989.
  13. ↑ "MultiMate V4.0". InfoWorld. January 29, 1990. p. 112. Multimate, Version 4.0 This significant upgrade ... a strong performer when producing office correspondence and mail merge
  14. ↑ "Variable Data Processor" . Retrieved 8 November 2020.
  15. ↑ "How To Use Yesware's Mail Merge for Gmail". Yesware's Mail Merge for Gmail allows users to send hundreds of personalized ...
  16. ↑ "Moovly fully integrates into Google's GSuite". The New York Times . September 25, 2018. Moovly has experienced strong growth ... into the Moovly Studio Editor, making the publishing of their video content ...
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.