– Has a maximum of 3,000 rows and/or 20 columns Here is a sample XLS file you can download for reference.Īlso, make sure that the database you are importing your data from: For example, if your first column contains everyone’s first names then cell A1 could say “First Names”. The data in your spreadsheet should be organized in columns, with the first row of your spreadsheet listing headers for what each column contains. Many programs allow you to export data into spreadsheets but you can also create your own in spreadsheet programs like Microsoft® Excel® or Google Sheets™. The most important document you will need for a mail merge is a spreadsheet with all of the data you need to import. We’ll walk you through all of the steps for mail merge in Design & Print so that you can shave valuable time off of your next project.
It might seem daunting at first but it’s actually very simple once you become familiar with the process. Mail merge is a versatile tool that can make your workflow and your life much easier.
