In the Label Options window, make sure that the Printer Information is set to Page Printers, Tray is set to Default Tray, and Label Vendor is set to Avery US Letter.
Click Start Mail Merge, then Step by Step Mail Merge Wizard.Ĭlick Labels and then click Next: Starting document. Mail Merge with the Step by Step Wizard in Microsoft WordĬlick the Mailings tab at the top of the screen. First, be sure your Excel spreadsheet has one column for each item you want, such as Name, Address, City, State and Zip Code and that this is in Sheet 1 of the spreadsheet file.
