how to mail merge labels from excel by last name

Step 5 - Specify Field Options Specify field options and click 'Next >' to advance to the next screen. Click the 'Next >' to advance to the next screen. Step 4 - Specify Data Source Settings Specify data source settings. Step 3 - Edit Mail Merge Settings Press the 'Edit Settings.' button to configure the mail merge parameters. Step 2 - Open the 'Mail Merge' Dialog Select 'Plug-Ins > Mail Merge.' to open the 'Mail Merge' dialog. Step 1 - Open a PDF Form Start the Adobe® Acrobat® application and using 'File > Open.' menu open a PDF form template that was prepared. This tutorial can be also used for older versions of Adobe Acrobat. You can download trial versions of both the Adobe® Acrobat® and the AutoMailMerge™. Prerequisites You need a copy of the Adobe® Acrobat® DC along with the AutoMailMerge™ plug-in installed on your computer in order to use this tutorial. Use this link to learn how to prepare a PDF form. Here is the example of the input PDF form that is used in this tutorial. We are going to show how to use 'Last name' and 'First name' data fields to customize output file names. The spreadsheet contains multiple rows of data with last name, first name, employee`s social security number (SSN) and an address.

Input Document Description The tutorial is using an Excel spreadsheet as a mail merge data source. The tutorial explains how to use any combination of custom text and data fields to create customized file names. Each output form will be automatically named using text from the 'Last name' and 'First name' data fields that are part of the sample Excel spreadsheet.

Tutorial Overview We are going to use the AutoMailMerge software to generate multiple W2 forms by filling a single PDF form template with data from a spreadsheet. This tutorial applies to AutoMailMerge™ plug-in for the Adobe® Acrobat®.

Naming Output Files Using Data Fields Introduction The tutorial shows how to name mail merge output PDF files using text from data fields.

How to mail merge labels from excel by last name