Search results
Learn how to Mail Merge with Microsoft 365, Office 2021, Office 2019, Office 2016, Office 2013, or Office 2010. Mail Merge allows you to send customized envelopes, letters, and emails.
- 7 min
- 1.9M
- Kevin Stratvert
Apr 30, 2021 · Poate fi cazul în care trebuie să trimitem invitații personale la un eveniment familie si prieteni, sau o scrisoare de afaceri de la serviciu. Principala utilitate a acestui lucru pe care o comentăm este că, în cele mai multe cazuri similare cu cele menționate, este probabil că va trebui să trimitem același document multor persoane.
Google's service, offered free of charge, instantly translates words, phrases, and web pages between English and over 100 other languages.
- Overview
- Creating a Contact Sheet
- Importing Contacts to Word
- Using Mail Merge
This wikiHow teaches you how to use the "Mail Merge" feature in Microsoft Word. Mail Merge allows you to use a spreadsheet of contact information to assign automatically a different address, name, or other piece of information to each copy of a document. This is useful when personalizing newsletters or statements, as you don't have to write by hand each person's name or address at the top of each document.
Create your contact sheet in Microsoft Excel. Add your headers beginning in column "A1" and moving right. Save your file and remember your save location.
Open Word and go to Blank document > Mailings > Select Recipients > Use an Existing List…. Choose your Excel sheet.
Go to the spot you want to insert contact information and click Insert Merge Field. Select the desired headers from your Excel document. Click Finish & Merge.
Microsoft Excel's app icon resembles a white "X" on a dark-green background. The Excel "New" page will open.
If you already have a contact sheet in Excel, skip ahead to
It's in the upper-left side of the "New" page. This will open a new, blank Excel document.
and moving right from there, enter the following headers:
- Your contacts' first names will go in this column (cell
- Your contacts' last names will go in this column (cell
The Word app icon looks like a white "W" on a dark-blue background. As with Excel, the "New" page will open.
If you have an existing Microsoft Word document into which you want to import the Excel contacts, you'll instead double-click it to open it and skip the next step.
It's a white box in the upper-left side of the page. A blank Microsoft Word document will open.
This tab is at the top of the Microsoft Word window. A toolbar will appear just below the row of tabs here.
It's in the "Start Mail Merge" section of the
toolbar. Doing so prompts a drop-down menu.
Go to the place in which you want to insert contact information.
Find the place where you want to insert contact information (e.g., the top of the document) and click it to place the cursor there.
It's an option in the "Write & Insert Fields" section of the
tab. A drop-down menu will appear.
You may have to click the
tab again before doing this.
Mail merge lets you create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.
Create and send personalized email messages to everyone on your address list with mail merge.
To use Mail Merge: Open an existing Word document, or create a new one. Click the Mailings tab. Click the Start Mail Merge command. Select Step by Step Mail Merge Wizard.
