![]() ![]() For this example, I’ll choose an Excel file. ![]() You can choose from your Outlook contacts, an Excel file, a database file, or even type in your own list. ![]() On the Mailings tab, click on the Select Recipients button. You will need to choose your recipients before you can set up the labels. Once you have turned on your non-printing characters in the step above, you can see your labels more clearly. Click on the home tab and on the show/hide button in the paragraph group. Turn on the show/hide characters to help you see the label edges. Your Word document will look about the same but it is already set up and formatted for the labels. For this example, we will choose a standard size label that is available for purchase in most office stores and online. There are address labels, filing labels, multimedia labels, and much more. On the label options dialog box, you can choose from a large variety of labels. Click on the Mailings tab and click the Start Mail Merge button. This will be your main document for the merge. Open a blank Word document and save it to your computer. For small and large businesses, creating labels can be a big time-saver. One of the best ways to start out with mail merge is to create basic mailing labels. Usually when I go through the steps with them, they realize it is much easier than it seems. In my past training classes, I have encountered many students who think it is too complicated since it involves several steps. If you are not using the mail merge feature, then you are missing out on a great tool. For more info, see Data sources you can use for a mail merge.įor more info, see Mail merge: Edit recipients.įor more info on sorting and filtering, see Sort the data for a mail merge or Filter the data for a mail merge.As I was getting my holiday cards ready to send recently, I realized again how useful mail merge was to create labels in Microsoft Word. Connect and edit the mailing listĬonnect to your data source. The Excel spreadsheet to be used in the mail merge is stored on your local machine.Ĭhanges or additions to your spreadsheet are completed before it's connected to your mail merge document in Word.įor more information, see Prepare your Excel data source for mail merge in Word. For example, to address readers by their first name in your document, you'll need separate columns for first and last names.Īll data to be merged is present in the first sheet of your spreadsheet.ĭata entries with percentages, currencies, and postal codes are correctly formatted in the spreadsheet so that Word can properly read their values. Make sure:Ĭolumn names in your spreadsheet match the field names you want to insert in your mail merge. Here are some tips to prepare your Excel spreadsheet for a mail merge. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |