Mail merge

<h2 id="history">History</h2>
Mail merge dates back to early word processors on personal computers, circa 1980.<a class="footnote-ref" id="fnref:4" href="#fn:4">4</a> <a href="/facts/WordStar/QWnaF7t7">WordStar</a><a class="footnote-ref" id="fnref:5" href="#fn:5">5</a><a class="footnote-ref" id="fnref:6" href="#fn:6">6</a> was perhaps<a class="footnote-ref" id="fnref:7" href="#fn:7">7</a> the earliest to provide this,<a class="footnote-ref" id="fnref:8" href="#fn:8">8</a> originally via an ancillary program called Mail merge. <a href="/facts/WordPerfect/x0R6HU9f">WordPerfect</a> also offered this capacity for CP/M and <a href="/facts/MS-DOS/fVrrz1uN">MS-DOS</a> systems;<a class="footnote-ref" id="fnref:9" href="#fn:9">9</a> <a href="/facts/Microsoft_Word/HPSu5W4j">Microsoft Word</a> added it later on,<a class="footnote-ref" id="fnref:10" href="#fn:10">10</a>
as did <a href="/facts/Multimate/nNDcU8Gf">Multimate</a>.<a class="footnote-ref" id="fnref:11" href="#fn:11">11</a><a class="footnote-ref" id="fnref:12" href="#fn:12">12</a><a class="footnote-ref" id="fnref:13" href="#fn:13">13</a><a class="footnote-ref" id="fnref:14" href="#fn:14">14</a><a class="footnote-ref" id="fnref:15" href="#fn:15">15</a>

<h2 id="advanced-features">Advanced features</h2>
Money can be saved by pre-sorting on zip code and grouping by postal-discount requirements (same ZIP code, same <a href="/facts/Sectional_Center_Facility/pfThUKQv">SCF</a>). 
A paperless approach is to use mail merge to format <a href="/facts/Email/6pD9GLtI">email</a>.<a class="footnote-ref" id="fnref:16" href="#fn:16">16</a>
Going beyond words, in 2018 The New York Times detailed a further instance of "mass customization" - personalized videos.<a class="footnote-ref" id="fnref:17" href="#fn:17">17</a>[relevant?]

<h2 id="overview">Overview</h2>
The data source is typically a table in a document, or a <a href="/facts/Spreadsheet/0cvc1GeB">spreadsheet</a> or <a href="/facts/Database/VYcpkevb">database</a> 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:

<ol><li>Creating a main document template.</li>
<li>Creating a data source.</li>
<li>Defining the merge fields in the main document template.</li>
<li>Merging the data source with the main document template.</li>
<li>Saving/exporting.</li></ol>
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 <a href="/facts/Variable_data_printing/4dVKElJz">variable data printing</a>. It can also be used to create address labels from a <a href="/facts/Customer_relationship_management/Y74q0uXB">customer relationship management</a> database, or for mass emails with pertinent information in them, perhaps a username and password.

<h2 id="see-also">See also</h2>
<ul><li><a href="/facts/Desktop_publishing/gUPtzSnH">Desktop publishing</a></li>
<li><a href="/facts/Digital_printing/kpyN6xVe">Digital printing</a></li>
<li><a href="/facts/Dynamic_publishing/hoUBphMy">Dynamic publishing</a></li>
<li><a href="/facts/Mass_customization/UWu7jQ69">Mass customization</a></li>
<li><a href="/facts/Comparison_of_word_processors/S70687h0">Word processors</a></li></ul>

<h2 id="external-links">External links</h2>

Look up mail merge in Wiktionary, the free dictionary.

<h2 id="references">References</h2>

<ol>
<li id="fn:1">"Cambridge Dictionary Online". Retrieved 14 May 2016. <a href="http://dictionary.cambridge.org/dictionary/english/mail-merge" target="_blank">http://dictionary.cambridge.org/dictionary/english/mail-merge</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></li>
<li id="fn: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 ... <a href="https://support.microsoft.com/en-us/help/826838/frequently-asked-questions-about-the-mail-merge-feature-in-word-2003-w" target="_blank">https://support.microsoft.com/en-us/help/826838/frequently-asked-questions-about-the-mail-merge-feature-in-word-2003-w</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></li>
<li id="fn:3">"Mail Merge". iSchool.uTexas.edu (Tutorials). Archived from the original on 2013-01-27. Retrieved 2018-11-02. <a href="https://web.archive.org/web/20130127094633/http://www.ischool.utexas.edu/technology/tutorials/office/mail_merge/" target="_blank">https://web.archive.org/web/20130127094633/http://www.ischool.utexas.edu/technology/tutorials/office/mail_merge/</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></li>
<li id="fn:4">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 <a href="http://www.bitsavers.org/pdf/microPro/Wordstar_3.3/Wordstar_Training_Guide_2ed_Feb83.pdf" target="_blank">http://www.bitsavers.org/pdf/microPro/Wordstar_3.3/Wordstar_Training_Guide_2ed_Feb83.pdf</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></li>
<li id="fn:5">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 <a href="http://www.bitsavers.org/pdf/microPro/Wordstar_3.3/Wordstar_Training_Guide_2ed_Feb83.pdf" target="_blank">http://www.bitsavers.org/pdf/microPro/Wordstar_3.3/Wordstar_Training_Guide_2ed_Feb83.pdf</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></li>
<li id="fn:6">"M Run Mail Merge. S Run SpellStar" <a href="#fnref:6" class="footnote-back-ref">↩</a></li>
<li id="fn:7">WinWorldPC citation says "the first" <a href="#fnref:7" class="footnote-back-ref">↩</a></li>
<li id="fn:8">"Software Spotlight: WordStar". WinWorld PC. WordStar was the first microcomputer word processor to offer mail merge <a href="https://forum.winworldpc.com/discussion/10379/software-spotlight-wordstar" target="_blank">https://forum.winworldpc.com/discussion/10379/software-spotlight-wordstar</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></li>
<li id="fn:9">"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 ... <a href="https://learn.corel.com/i-love-wordperfect-contest" target="_blank">https://learn.corel.com/i-love-wordperfect-contest</a> <a href="#fnref:9" class="footnote-back-ref">↩</a></li>
<li id="fn:10">"WordStar MailMerge". 29 April 1986. Retrieved 20 May 2016. <a href="https://books.google.com/books?id=lmtbry-ytXgC&dq=mail+merge+dos&pg=PA168" target="_blank">https://books.google.com/books?id=lmtbry-ytXgC&dq=mail+merge+dos&pg=PA168</a> <a href="#fnref:10" class="footnote-back-ref">↩</a></li>
<li id="fn:11">"Early" magazine articles about Multimate's Mail Merge were largely 1988-1990" <a href="#fnref:11" class="footnote-back-ref">↩</a></li>
<li id="fn:12">"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. <a href="https://books.google.com/books?id=CmNNyCje8oAC" target="_blank">https://books.google.com/books?id=CmNNyCje8oAC</a> <a href="#fnref:12" class="footnote-back-ref">↩</a></li>
<li id="fn:13">"Multimate Mail Merge". InfoWorld. January 23, 1989. <a href="https://books.google.com/books?id=KzoEAAAAMBAJ" target="_blank">https://books.google.com/books?id=KzoEAAAAMBAJ</a> <a href="#fnref:13" class="footnote-back-ref">↩</a></li>
<li id="fn:14">"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 <a href="https://books.google.com/books?id=fjAEAAAAMBAJ" target="_blank">https://books.google.com/books?id=fjAEAAAAMBAJ</a> <a href="#fnref:14" class="footnote-back-ref">↩</a></li>
<li id="fn:15">"Variable Data Processor". Retrieved 8 November 2020. <a href="https://sourceforge.net/projects/vdprocessor" target="_blank">https://sourceforge.net/projects/vdprocessor</a> <a href="#fnref:15" class="footnote-back-ref">↩</a></li>
<li id="fn:16">"How To Use Yesware's Mail Merge for Gmail". Yesware's Mail Merge for Gmail allows users to send hundreds of personalized ... <a href="https://www.yesware.com/blog/help/how-to/using-mail-merge-automated-follow-ups" target="_blank">https://www.yesware.com/blog/help/how-to/using-mail-merge-automated-follow-ups</a> <a href="#fnref:16" class="footnote-back-ref">↩</a></li>
<li id="fn:17">"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 ... <a href="https://markets.on.nytimes.com/research/stocks/news/press_release.asp?docTag=201809250305PRIMZONEFULLFEED7392461%26feedID=600%26press_symbol=140864" target="_blank">https://markets.on.nytimes.com/research/stocks/news/press_release.asp?docTag=201809250305PRIMZONEFULLFEED7392461%26feedID=600%26press_symbol=140864</a> <a href="#fnref:17" class="footnote-back-ref">↩</a></li>
</ol>

Mail merge open-in-new

Mail merge