How do I Mail Merge?

To perform a mail merge in DPO, follow the instructions below. If you'd prefer to watch a video, please see How to Import Data or Mail Merge Using Avery Design & Print Online

Prerequisites

• Your spreadsheet (in either xls, xlsx, csv format) containing data you wish to use for your mail merge.

1. In DPO on the left-hand pane, select "Import Data".
2. Press "Start Import/Merge".
   

3. Click on "browse for file" and navigate to the data source file that contains the information to be merged into your labels. Acceptable file types are xls, xlsx, csv files.
   

   Note: If you have a row of headings in your data (like First Name, Surname, Street Address etc), ensure the Use first row as headings is ticked. You will be able to scroll through your data and de-select entries.

4. When you have finished selecting or de-selecting entries, click Next.
   
5. On the Mail Merge – Arrange Fields screen, drag and drop fields to the appropriate position. Design & Print Online will add a space between fields for you. You can add commas, line spaces and other text between fields. When you’ve finished, click on Next.
   
6. Click on Finish when you are done.
7. Your mail merge information will now appear on each label. You can now format your labels. When you are finished your design, click Preview & Print at the top or bottom of your screen.