Or, it can combine several entries, for example the «AddressBlock» field. A merge field can correspond to one entry such as first name, last name, city, zip code, etc. In essence, when you mail merge labels or envelopes from Excel to Word, the column headers of your Excel sheet are transformed into mail merge fields in a Word document. The steps are essentially the same in Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2010, and very similar in Excel 2007. Whatever intricate and intimidating the task may sound, it boils down to 7 basic steps.īelow, we'll take a closer look at each step using Microsoft 365 for Excel. If you've had a chance to read our Mail Merge tutorial, a larger part of the process will be familiar to you because making labels or envelopes from Excel is yet another variation of the Word Mail Merge feature. Repeat the process of clicking inside each label and inserting the desired image.How to mail merge address labels from Excel Navigate to and click on the image to add to the label. The labels display in the selected template.Ĭlick inside a label where the image will be placed, and then click the “Insert” tab on the top navigation ribbon.Ĭlick the “Picture" option. Click “OK.”Ĭlick the “New Document” button. The new label you are creating is formatted for the template for the selected label product. The Product Number field populates with products produced by the specified vendor.Ĭlick the “Product Number” for the label you will use. A list of label vendors and product numbers opens.Ĭlick the “Label Vendor” drop-down box and click the vendor of the labels you will print. Highlight the text and right-click to change the justification and font of the text. Type the first recipient’s address into the “Address” input box. Click the “Labels” option on the left side of the navigation ribbon.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |