How to Mail Merge using Avery Design & Print Online
How to Mail Merge using Avery Design & Print Online

After you select a template and a pre-design, the Customize screen appears. Select a text box then click Start Mail Merge under the Import Data (Mail Merge) tools.

Click the Browse for File button to select an address list or other data from Microsoft® Excel or another data program on your computer. Click Upload.

If you don't have a spreadsheet with all of your names and addresses, you can start with our pre-formatted files for Microsoft® Excel or other database programs.

After uploading the data, the address list will be displayed for your review. You can choose which rows of data in the list to use, whether to sort by column, or edit the data. Uncheck the Print this row of data box if you do not want to print the first row of your data. Click the Next button when you are finished reviewing the data.

Drag and drop the data from the Available fields area into the Arrange fields area. Click Complete Merge to continue.

Make any formatting changes if desired. Click Preview & Print to continue.

At any point, click the Help button in the program for more instructions.