Mail merge

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

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

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. ^ a b 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 ...

Read other articles:

Clare Stewart di festival tahun 2016 Festival Film London BFI (Inggris: BFI London Film Festivalcode: en is deprecated ) adalah sebuah festival film tahunan yang diadakan di Britania Raya, yang diadakan pada paruh kedua Oktober dengan kerjasama dari British Film Institute. Festival tersebut menayangkan lebih dari 300 film, dokumenter dan film pendek dari sekitar 50 negara. Referensi Pranala luar bfi Homepage Diarsipkan 2019-07-31 di Wayback Machine. London Film Festival Homepage Diarsipkan 20...

 

 

German television channel Television channel VH-1ProgrammingPicture format576i (4:3 SDTV)OwnershipOwnerMTV Networks InternationalHistoryLaunched10 March 1995; 29 years ago (1995-03-10)Closed1 May 2001; 22 years ago (2001-05-01)Replaced byMTV2 PopLinksWebsitehttp://www.vh1.de (defunct) VH-1 Deutschland (VH-1 Germany) was a localised German version of the Viacom channel VH1 that was on air from 1995 until 2001. The programme was operated by Me, Myself & E...

 

 

Cet article est une ébauche concernant le Venezuela. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Chronologie en Amérique 2007 au Venezuela - 2008 au Venezuela - 2009 au Venezuela - 2010 au Venezuela - 2011 au Venezuela 2007 par pays en Amérique - 2008 par pays en Amérique - 2009 par pays en Amérique - 2010 par pays en Amérique - 2011 par pays en Amérique Chronologies Données clés 2006 2007 2008 ...

Cet article est une ébauche concernant l’histoire et l’islam. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Consultez la liste des tâches à accomplir en page de discussion. Pour les articles homonymes, voir Al-Mansur. Mansur al-Amir Bi-AhkamillahDinar fatimide AV (4,14 g, 9h) frappé au Caire (Egypte) en 514 AH (1119/20 AD) sous le règne d'al-Amir bi-Ahkam AllahFonctionCalife fatimide1101-1130Al-Musta'...

 

 

Football match1926 FA Cup finalProgramme coverEvent1925–26 FA Cup Bolton Wanderers Manchester City 1 0 Date24 April 1926VenueWembley Stadium, LondonRefereeI. BakerAttendance91,447← 1925 1927 → The 1926 FA Cup final was a football match between Bolton Wanderers and Manchester City on 24 April 1926 at Wembley Stadium in London. The showpiece match of English football's primary cup competition, the Football Association Challenge Cup (better known as the FA Cup), it was the 55th fi...

 

 

1942 transport aircraft family by Avro Type 685 York LV633 Ascalon, Churchill's personal aircraft. Role TransportType of aircraft Manufacturer Avro Designer Roy Chadwick First flight 5 July 1942 Introduction 1944 Retired 1964 Status Two examples on display Primary users Royal Air ForceBOACBritish South American AirwaysSkyways Ltd Produced 1943–1948 Number built 258 (including 4 prototypes) Developed from Avro Lancaster The Avro York was a British transport aircraft developed by Avro du...

DVD box set Adult Swim in a Box is a seven-disc DVD box set produced by Williams Street and released by Warner Home Video on October 27, 2009. The box set contains various seasonal volume releases from Adult Swim series, as well as several pilots that were pitched to the network. The box set was first announced by Warner Home Video on July 31, 2009, to be released in October of the same year. The set was promoted as having a roughly threefold value, totaling 21 hours and 20 minutes of content...

 

 

この項目には、一部のコンピュータや閲覧ソフトで表示できない文字が含まれています(詳細)。 数字の大字(だいじ)は、漢数字の一種。通常用いる単純な字形の漢数字(小字)の代わりに同じ音の別の漢字を用いるものである。 概要 壱万円日本銀行券(「壱」が大字) 弐千円日本銀行券(「弐」が大字) 漢数字には「一」「二」「三」と続く小字と、「壱」「�...

 

 

† Палеопропитеки Научная классификация Домен:ЭукариотыЦарство:ЖивотныеПодцарство:ЭуметазоиБез ранга:Двусторонне-симметричныеБез ранга:ВторичноротыеТип:ХордовыеПодтип:ПозвоночныеИнфратип:ЧелюстноротыеНадкласс:ЧетвероногиеКлада:АмниотыКлада:СинапсидыКласс:�...

Kanagawa at-large district神奈川県選挙区Parliamentary constituencyfor the House of CouncillorsPrefectureKanagawaElectorate7,732,893 (as of September 2022)[1]Current constituencyCreated1947Seats8CouncillorsClass of 2019:   Vacant[a]  Motoko Mizuno (CDP)  Sayaka Sasaki (Komeito)  Hiroe Makiyama (CDP)[b] Class of 2022:   Junko Mihara (LDP)  Shigefumi Matsuzawa (Ishin)  Shinsuke Miura (Komeito)  Keiichiro Asao (LDP) The Kanaga...

 

 

Державний комітет телебачення і радіомовлення України (Держкомтелерадіо) Приміщення комітетуЗагальна інформаціяКраїна  УкраїнаДата створення 2003Керівне відомство Кабінет Міністрів УкраїниРічний бюджет 1 964 898 500 ₴[1]Голова Олег НаливайкоПідвідомчі ор...

 

 

LGBT rights in GuyanaGuyanaStatusIllegalPenaltyUp to life in prison (not enforced; decriminalisation proposed)Gender identityNoMilitaryNoDiscrimination protectionsNoneFamily rightsRecognition of relationshipsNo recognition of same-sex relationshipsAdoptionUnclear Lesbian, gay, bisexual, and transgender (LGBT) people in Guyana face legal and societal challenges not experienced by non-LGBT residents. Guyana is the only country in South America, and the only mainland country in the Americas, wh...

This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages) This biography of a living person needs additional citations for verification. Please help by adding reliable sources. Contentious material about living persons that is unsourced or poorly sourced must be removed immediately from the article and its talk page, especially if potentially libelous.Find sources: Scott Blake – ne...

 

 

Galería de la Historia de Concepción Entrada principal de la GaleríaUna de las dos entradas del museo. Enero de 2019UbicaciónPaís  ChileCoordenadas 36°50′02″S 73°03′01″O / -36.83378056, -73.05014722Tipo y coleccionesTipo Museo, Museo de historia y Museo privadoHistoria y gestiónCreación 1983y http://www.ghconcepcion.cl Sitio web oficial[editar datos en Wikidata] La Galería de la Historia de Concepción (GHC) es un museo inaugurado en 1983, ubic...

 

 

Alphanumeric code specifying tire sizes and limits Assorted new car tires with a variety of tread patterns and different sizes Automotive tires are described by an alphanumeric tire code (in North American English) or tyre code (in Commonwealth English), which is generally molded into the sidewall of the tire. This code specifies the dimensions of the tire, and some of its key limitations, such as load-bearing ability, and maximum speed. Sometimes the inner sidewall contains information not i...

Liga Arab memiliki 22 negara anggota. Liga Arab didirikan di Kairo pada tahun 1945 oleh Mesir, Irak, Lebanon, Arab Saudi, Suriah, Yordania, dan Yaman (Yaman Utara, kemudian disatukan dibawah negara Yaman). Ada peningkatan jumlah keanggotaan selama paruh kedua abad ke-20, dengan tambahan 15 negara Arab dan 4 pengamat. Israel tidak termasuk dalam keanggotaan meskipun 20 % dari penduduknya terdiri dari Arab Palestina, hampir setengah penduduk Yahudi juga diturunkan dari orang Yahudi dari ne...

 

 

Book by William Shatner This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Avenger Shatner novel – news · newspapers · books · scholar · JSTOR (December 2009) (Learn how and when to remove this message) Avenger AuthorWilliam ShatnerLanguageEnglishGenreScience fictionPublished1997Publication placeUnited StatesPreceded b...

 

 

Item of metadata attached to a document For the Wikipedia help page, see WP:ANNOTATION. This article has multiple issues. Please help improve it or discuss these issues on the talk page. (Learn how and when to remove these template messages) This article's lead section may be too short to adequately summarize the key points. Please consider expanding the lead to provide an accessible overview of all important aspects of the article. (February 2015) This article needs additional citations for ...

Artikel ini sebatang kara, artinya tidak ada artikel lain yang memiliki pranala balik ke halaman ini.Bantulah menambah pranala ke artikel ini dari artikel yang berhubungan atau coba peralatan pencari pranala.Tag ini diberikan pada Desember 2022. Wolf AckvaLahir(1911-07-30)30 Juli 1911Montigny, Jerman (kini Montigny-lès-Metz, Prancis)Meninggal16 Januari 2000(2000-01-16) (umur 88)Fahrenzhausen, JermanPekerjaanPemeranTahun aktif1935-1996 Wolf Ackva (30 Juli 1911 – 16 J...

 

 

Pour les articles homonymes, voir Frayssinet. Frayssinet Mairie de Frayssinet. Administration Pays France Région Occitanie Département Lot Arrondissement Gourdon Intercommunalité Communauté de communes du Causse de Labastide-Murat Maire Mandat Claude Saint-Martin 2020-2026 Code postal 46310 Code commune 46113 Démographie Populationmunicipale 304 hab. (2021 ) Densité 18 hab./km2 Géographie Coordonnées 44° 39′ 47″ nord, 1° 29′ 00″ est A...