how to print address labels from excel to word

How to print address labels from excel to word update#

Back at the top menu select “Finish & Merge” and then “Edit Individual Documents” ~ from here you can go ahead and select “All” ( Tip: If you only want to print a certain range from your Excel sheet you can select the “From to To” option shown.

Now you are ready to pull the data in from your Excel sheet into the actual label template you have just finished creating.

How to print address labels from excel to word update#

that you defined on label one and automagically update the rest of the page of labels. Once Label One is laid out exactly how you like go back to the top menu and select “Update Labels” ~ this will take the merge fields, formatting, etc.You can edit font type and size using normal Word formatting options ~ just be sure your font/text does not go outside of the guidelines shown on the screen.Each merge field needs to be inserted onto the label in the exact layout you want the final, merged labels to print. On your menu bar select “Insert Merge Field” ~ the fields shown on this drop down should be the exact column headings you defined in your Excel sheet.With your cursor in the first label we now want to set up the merge fields.Your document should now show “Next Record” in all labels (except for the first one).The pop up screen that displays next – just select “OK”.Navigate and select the Excel file you saved from Part One above.On your menu bar at the top select “Select Recipients” and then chose “Use Existing List”.A new document should be shown on your screen with the label “guidelines” shown on the document ~ this represents each label and gives you a visualization on how the finished product will look once the remaining steps are completed.Click “OK” once you’ve selected the appropriate label type. A pop-up window is displayed allowing you to select the type of label you are creating (the most popular mailing labels are Avery 5160).

From the Mail Merge options you want to select “Labels”.Click “Start Mail Merge” (in older versions of Word I believe this is called Mail Merge Wizard).Open a new document in Word and go to the Mailings section.