You need to make sure everything looks good to print.Ĭlick on the "File" tab in the program, then choose "Print Preview." This will load a window and display exactly how the document will look after you print it. You are now at the final stages of the how to print labels from Excel instructions. Now, click "OK." Click "OK" a second time to exit out of the dialog box and then click back on the "Mailing" tab, followed by "Write & Insert Fields," and finally "Update Labels."Įverything has now been imported and your labels are ready to go. Scroll through the display window and, if any changes need to be made, click on the drop-down arrow next to the display and make the necessary edits. Look over the displayed information to make sure it is entered in properly (it should be, as long as you typed everything into Excel correctly). The window will now display what the labels will look like should you accept the input information. Choose "Insert Address Block" from the window and then click on "Match Fields." Now choose "Write & Insert Fields" from the pull-down menu and finally click on "Address Block."Ī new set of options will appear on the screen. In order to do this, you will need to select the first label listed on your Microsoft Word document and then click on "Mailings" from the top of the screen. This way, the labels will appear correctly within Microsoft Word, allowing you to print the data. With everything connecting as it should, your next step for how to print labels from Excel is to connect mail merge fields.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |