How to Automate PDF Business Card Mail Merge for Names and Dates
Question details
The user needs a method to automate adding distinct names and optional dates to multiple business cards arranged on a single PDF page without manually editing each one.

- Product
- Device & OS
- not provided
- Scenario
- Generating multiple personalized business cards from a single layout template by merging a data list of names and dates.
- Observed behavior
- The user wants to transition from manually typing individual details on each PDF card to an automated bulk generation process.
Prepare a spreadsheet (such as an Excel file) containing the names and optional dates you wish to merge, ensuring each column has a clear header like 'Name' and 'Date'.
Use Microsoft Word or WPS Writer for Mail Merge
The simplest approach is to recreate the business card layout in a word processor and use its built-in mail merge feature, as native PDF editors often lack straightforward bulk data merge options.
Instead of struggling with advanced PDF scripts, you can use the original PDF as a background image in a Word document and map your spreadsheet data over it.
Open your word processor, create a new document, and go to the 'Mailings' or 'References' tab. Select 'Labels' to define the grid matching your business card dimensions.
Click 'Select Recipients' or 'Open Data Source' and choose the spreadsheet containing your list of names and dates.
Place your cursor in the first business card slot and click 'Insert Merge Field' to add the 'Name' and 'Date' fields. Apply the 'Next Record' rule for subsequent cards on the page.
Click 'Preview Results' to ensure the names and dates populate correctly. Finally, click 'Finish & Merge' and choose to print or export the final merged document as a PDF.

Use PDF Form Fields and Automation Scripts
If you must work strictly within the PDF format, you can convert the page into a template and use custom scripts to populate form fields.
Automate Your Business Card Generation with WPS Office
WPS Office provides a highly compatible Writer tool with a robust built-in Mail Merge feature, allowing you to easily import data from spreadsheets, populate multiple business cards per page, and export the final result directly to a high-quality PDF.
- 1. Create your template: Open WPS Writer, set your page layout to match your business cards, and optionally insert your design as a background.
- 2. Open data source: Navigate to the 'References' tab, click 'Mail Merge', and select 'Open Data Source' to link your spreadsheet of names and dates.
- 3. Insert fields: Click 'Insert Merge Field' to place placeholders for your text. Use 'Next Record' to ensure each card gets unique data.
- 4. Merge to PDF: Click 'Merge to New Document' to generate all pages, then click 'Export to PDF' to save your automated business cards.

Frequently Asked Questions
Can I directly mail merge from an Excel file into a standard PDF document?
Most standard PDF editors do not have native, user-friendly mail merge functions linked directly to Excel. It is generally easier to perform the mail merge in a word processor like WPS Writer and then export the finalized document to a PDF.
How do I print multiple different business cards on a single page using mail merge?
You need to use the 'Labels' feature in your word processor's mail merge settings. This allows you to set up multiple records per page. Inserting a 'Next Record' rule after each card layout tells the software to pull the next name from your list.
Are there automated tools to merge data specifically into PDF form fields?
Yes, advanced PDF tools support JavaScript or third-party plugins that can map data from CSV or XML files into PDF form fields. However, this often requires custom scripting knowledge, making word processor mail merge a more accessible alternative.




