Which of the following is not used when creating a mail merge document

Copyright This document is Copyright © 2021 by the LibreOffice Documentation Team. Contributors are listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License ( All trademarks within this guide belong to their legitimate owners. To this edition Jean Hollis Weber Kees Kriek Rafael Lima To previous editions Jean Hollis Weber Toni Blackwelder Kees Kriek Shravani Bellapukonda Randolph Gamo Jenna Sargent Dante Legaspi Felipe Viggiano Pulkit Krishna Colleen Hayes John A Smith Peter Schofield Bruce Byfield Gillian Polack Cathy Crumbley Hazel Russman Leo Moons David Blymire Jeremy Cartwright John M. Długosz Barbara Duprey Jamie Eby Ron Faile Jr. Gary Schnabl Klaus-Jürgen Weghorn Rafael Atias Please direct any comments or suggestions about this document to the Documentation Team’s mailing list: Note Everything you send to a mailing list, including your email address and any other personal information that is written in the message, is publicly archived and cannot be deleted. Published April 2021. Based on LibreOffice 7.1 Community. Other versions of LibreOffice may differ in appearance and functionality. Writer’s mail merge provides features to create and print multiple copies of one item (such as return address labels, promotional stickers, or t-shirt transfers) or to produce copies that include variable information (for example names, addresses, and amounts due): • Form letters (a document to send to a list of recipients) • Maili...

Summary This article explains how to use the Mail Merge feature in Microsoft Word to create and to print form letters by using data from a Microsoft Excel worksheet. When you use the Word Mail Merge feature, Word merges a main document with a recipient list to generate a set of output documents: • The main document contains the basic text that is the same in all of the output documents. It may contain a letterhead, text, and instructions in merge fields for inserting text (such as recipient names and addresses) that vary from one output document to another. • The recipient list is a database that contains the data that is to be merged into the output documents. For example, the recipient list is a Microsoft Access database file or an Excel worksheet. This database is typically a list of names, addresses, phone numbers, and other categories of personal information. • The output documents are the result of the mail merge. The text in an output document can be the same in all output documents, but you can apply formatting to specific documents. Step 1: Set Up the Excel Data File Before you proceed with the Mail Merge Wizard, make sure that your Excel worksheet is well structured for this purpose. Note the following requirements for the data table: • The first row should contain field names for each column -- for example, Title, Salutation, First Name, Middle Name, Last Name, Address1, and Address2. • Each field name should be unique. • Each row should provide information abou...

Sandy Writtenhouse Writer With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. Now you can RELATED: How to Create Mailing Labels in Word from an Excel List Use an Existing List: Pick this option and click “Browse” to locate your file. When it opens in Word, you’ll see a box where you can refine your list if you like. Sort, filter, find duplicates, or validate the addresses. You can also use the checkboxes to select and deselect recipients. Select From Outlook Contacts: Mark this option and click “Choose Contacts Folder” to pick the folder. You’ll then see the contacts from that folder appear in a box just like above where you can refine your list. You can then choose from the blocks you see to add the recipient details to your message. Address Block: Place your cursor in the document where you want the address block. Then, choose a format for the recipient names, whether you want to include a company name or postal address, and other details about the location. You’ll then see a preview of the letter with the variables filled in with your When you finish, click “Next: Complete the Merge” and then select...

This article will help you get answers to the most common mail merge issues when using Publisher: Making changes to a data source or address list during the mail merge process, adding spaces to a merge field so that it looks the way you want it to, saving the merged publication, and printing different merged pages on a sheet (for example, different labels on a sheet of labels). Edit an existing address list If you're working on your merge publication and you want to make changes to your data source or address list, do the following: • Under Create recipient list, click Use an existing list, and then click Next: Create or connect to a recipient list. By default, Microsoft Publisher stores data sources in the My Data Sources folder. You may need to browse to locate your data source. • In the Select Data Source dialog box, click the data source that you want. • Click Open. Depending on the type of data source that you select, other dialog boxes may appear requesting specific information. For example, if your data source is a Microsoft Office Excel workbook that has information on multiple worksheets, you need to select the worksheet that contains the information that you want, and then click OK. • In the Mail Merge Recipients dialog box, click the name of the data source and then click Edit. • In the Edit Data Source box you can edit or delete existing addresses, or add new entrys. • When you are done editing the address list, click OK and then Yes to update the address list....

Here are some tips to prepare your Excel spreadsheet for a mail merge. Make sure: • Column names in your spreadsheet match the field names you want to insert in your mail merge. For example, to address readers by their first name in your document, you'll need separate columns for first and last names. • All data to be merged is present in the first sheet of your spreadsheet. • Data entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. • The Excel spreadsheet to be used in the mail merge is stored on your local machine. • Changes or additions to your spreadsheet are completed before it's connected to your mail merge document in Word. Notes: • You can import information from your Excel spreadsheet by importing information from a comma-separated value (.csv) or a text (.txt) file and use the Text Import Wizard to build a new spreadsheet. • For more information, see Connect and edit the mailing list Connect to your data source. For more info, see Edit your mailing list • Choose Edit Recipient List. • In Mail Merge Recipients, clear the check box next to the name of any person who you don't want to receive your mailing. You can insert one or more mail merge fields that pull the information from your spreadsheet into your document. To insert merge fields on an envelope, label, email message, or letter • Go to Mailings> Address Block. For more info, see • To add a greeting line, choose Greeti...

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. Placeholders--called merge fields--tell Word where in the document to include information from the data source. You work on the main document in Word, inserting merge fields for the personalized content you want to include. When the mail merge is complete, the merge document will generate a personalized version of itself for each name in the data source. Data sources Your first step in setting up a mail merge is to pick the source of data you'll use for the personalized information. Excel spreadsheets and Outlook contact lists are the most common data sources, but any database that you can connect to Word will work. If you don't yet have a data source, you can even type it up in Word, as part of the mail merge process. For details about data sources, see Excel or Outlook If you know you'll be using Excel or Outlook as the source of your data, see: • • Document types Word provides tools for incorporating your data into the following kinds of documents. Follow the links for details about each type: • Letters that include a personalized greeting. Each letter prints on a separate sheet of paper. • Email where each recipient's address is the only address on the To line. You'll be sending the email directly from Word. • En...