Mail Merge

Lucidpress’s mail merge feature is perfect for shipping personalized documents to multiple addresses. Mail merge allows the instantaneous creation of customized documents that can then be shipped wherever you please. These documents are customized by linking a template to a .csv file.

Mail merge is available to Basic, Professional, Team, and Enterprise Accounts. To upgrade, visit our pricing page.

The following steps will show you how to customize and ship your documents.

  1. Prepare a .csv containing the data that you would like to customize on each document.

Note: The header names will be a place holder on your template; be sure to use names that will allow you to keep track of your data.

Screen_Shot_2017-05-10_at_9.45.34_AM.png

  1. Create a mail merge smart field by opening the Lucidpress template you wish to customize. Highlight the text you wish to replace, right click, and choose “Insert Mail Merge field.” This can also be done from the “File” menu.

    Screen_Shot_2017-05-11_at_8.26.28_AM.png
  2. In the dialog box that appears, label your field. We recommend using the header name as your label to avoid confusion. Click “OK.” Repeat steps 2 and 3 until all of the desired smart fields have been created.

    Screen_Shot_2017-05-11_at_8.28.19_AM.png
  1. When you are ready to print and ship your document, click on the “Order Prints” button found in the top-right corner of the screen. Select the desired product type and size. Click “Next.”

    Screen_Shot_2017-05-11_at_8.31.15_AM.png
  2. If you have a mail merge smart field on the document you are printing, a dialog box will appear where you can upload the .csv file used to create your smart fields.

    Screen_Shot_2017-05-11_at_8.34.09_AM.png
  3. Select how you would like to identify each customized document by selecting the column header in the "Indentify PDF by" drop down menu. If there is not a column that identifies your document in the .csv file, the row number will be used. The identifier will be used in the cart to distinguish documents from destinations if you would like to ship to multiple addresses.

    Screen_Shot_2017-05-11_at_8.35.50_AM.png
  4. After your .csv has been uploaded, match the smart field labels created in step 3 to the correct .csv headers that appear in the "Value" drop down lists.

Note: The fields in your Lucidpress template will be replaced for each customized document on a row by row basis according to the data in your .csv document.

  1. Proceed through the checkout process. Lucidpress will automatically populate individual documents with the corresponding data in your .csv.

    Screen_Shot_2017-05-11_at_8.41.26_AM.png
  2. Once your documents have been generated, you can download the first proof or all of the proofs. Be sure to review your PDF to make sure that everything is correct. If everything is satisfactory, proceed by clicking “Approve & Add to Cart."

    Screen_Shot_2017-05-11_at_9.15.36_AM.png
  3. In the cart, you will see your documents as they will appear when printed. Each document name now corresponds to the identifier selected in step 6.

    Screen_Shot_2017-05-11_at_9.16.44_AM.png
  4. To ship to multiple addresses, select the multi address shipping view. This will allow you to determine the addresses to which you would like each line item shipped.

    Screen_Shot_2017-05-11_at_9.18.12_AM.png

Note: If you would like to download data merged PDFs without using the print and ship option, follow the same steps by clicking the “Download” button in the top-right corner of the screen.