How to make Avery L4731 in Excel?
It’s much easier to do this in Google Sheets using Foxy Labels Add-on. But in case you like Excel take these steps:
- To mail merge Avery L4731, create a new Excel Sheet, type in a heading in each column’s first cell describing the data. Make a column for each element you want to include on the labels.
- Type the names and addresses or other data you’re planning to print on labels.
- Open Word document. Click Mailing ->Start Mail Merge ->Labels. Select the template.
- Click Select Recipients -> Use an Existing List in the dialog window, then select created file.
- Click on Insert Merge Field to input data from the Excel file.
- Don’t forget to click on Preview Results before printing.
How to make Avery L4731 in Word?
It’s much easier to do this in Google Docs using Foxy Labels Add-on. But in case you like Word, take these steps:
- To set up Avery L4731 template, open a Word document, go to the top of the screen and click Mailings > Labels > Options.
- Select Avery US Letter from the drop-down menu next to Label Vendors. Then scroll to find your Avery product number and click OK. Download Avery L4731 template for Microsoft Word
- If you want all of your created labels to have the same information, type it into the address box and click New Document. If you want different information on each title, click New Document and then fill in your labels.
- If you would like to see gridlines, click Layout > View Gridlines.
- The template is ready to print.
Other templates Us Letter Format: