If You've Got Questions,
We've got Answers
We're here to Help!
Most Popular Questions
How to Mail Merge in Design & Print Online
The term "Mail Merge" describes a process which takes data from one source and applies it to another.
By using Mail Merge you can rearrange information into a new format using fields taken from a database at the touch of a few buttons. Importing data is great for address labels, invitations, personalized meeting materials or party bags, and name tags or name badges.
Start by clicking the Import Data button on the left of the Customize screen. The left panel opens up with an option to watch a See How video or to get started by clicking Import Data.
First, select to Browse for file on your computer to open a spreadsheet you’ve previously saved on your computer. You can use xls, xlsx or csv files. If you use Google Drive, you can download your spreadsheet either as an xls or csv file. Most spreadsheet software programs have an option to save as a csv file.
Example of a Microsoft® Excel® Spreadsheet:
Each column represents a merge field. Each row represents one address.
Microsoft Excel workbooks that contain a single spreadsheet are the easiest to import. However, your workbooks may contain two or more spreadsheets. Spreadsheets in a workbook are reordered alphabetically when uploaded. Regardless of the tab order, the tab name that is first alphabetically is used. You can re-name a tab to make it the one that’s used.
Next you’ll see your data in the Confirm List window. You can uncheck any columns or rows you don’t want to appear. If your list has a header row, un-check the first row so you don’t print a label with your header information on it.
If everything looks right, click the green Next button at the bottom of the window. If you want to go back and select a different list or edit your list, click Back.
Next you need to arrange the fields that you want to put onto your project.
Each item on the left in the Available Fields area corresponds to a column of data in your spreadsheet. These field names are actually the column headings shown in the previous screen.
Note: Merge fields are not automatically assigned. You will need to insert and arrange the field names.
Select each of the items from the left and drag it to the Arrange fields area. (You can also double-click.)
Add spaces and commas where needed, or use the Enter key to create a new line.
When you are finished inserting the field names, click Next.
Next, an information screen will appear explaining what you can do next:
Click Finish and you can edit your data on the Customize screen.