Adobe® Acrobat® plug-in · Trusted since 2006

Auto-populate PDF forms from Excel, generate thousands of documents in minutes.

AutoMailMerge is PDF mail merge software for Adobe® Acrobat®. Fill PDF forms from Excel, CSV, Access, or any database to generate personalized PDF documents — one per record, or multiple records combined into a single file, secured, signed, and emailed automatically.
Trusted by federal agencies. SAM-registered, NASA SEWP-approved.

  • One-time License
  • 2 years of maintenance
  • 30+ tutorials
  • 100% Secure Offline Processing
  • Requires Acrobat® Standard/Pro
  • Windows OS
Excel spreadsheet data populating multiple PDF forms automatically

Trusted by 50,000+ professionals at:

IRS Deloitte PricewaterhouseCoopers KPMG Ernst & Young Bank of America WellsFargo United Health Group State Farm Stanford University UCLA Harvard University Novartis Amazon NASA USDA UBS Group AG Oxford and Cambridge Education

How it works

From spreadsheet to signed PDFs in three steps

Stop copy-pasting into PDF after PDF. Set up once, run forever.

01

Open your PDF form in Acrobat®

Use any fillable PDF — invoices, tax forms, certificates, contracts. Turn any office document into fillable PDF in few clicks. AutoMailMerge adds a menu directly inside Adobe® Acrobat®.

02

Connect your Excel or database

Map spreadsheet columns to PDF fields with the visual or textual mapper. Filter data rows you need or use the whole sheet.

03

Generate, secure, and email

Create personalized PDFs per one or more records, watermark, name files dynamically from data fields, password-protect or digitally sign, and email each one automatically.


Diagram showing an Excel spreadsheet used to fill out stack of PDF forms

Use cases

One tool. Built from years of getting this right.

Accounting & CPA Firms

Bulk-fill PDF statements by merging data straight from Excel or CSV files. Personalize each PDF with the customer's own balance, transactions, and due date, then send it as an attachment automatically. Prepare W-2, 1099, 1098 and K-1 tax forms, and accounts receivable statements.

Tax forms (W-2, 1099, K-1)

Populate IRS and state tax forms for every employee or contractor by pulling data directly from your existing payroll or accounting files. Built for accountants, payroll teams, and small businesses filing W-2s, 1099-NEC, 1099-MISC, and K-1s at tax season.

Insurance

Generate per-policy declarations, claim and policy renewal forms, certificates of insurance and coverage certificates pulled from your policy database. Populate ACORD 25 certificates of liability insurance, ACORD 27 evidence of property insurance and ACORD 28 evidence of commercial property insurance forms.

Legal & Law Firms

Produce NDAs, agreements, affidavits, subpoenas and deposition notices, discovery requests and responses, engagement letters customized per client — keep them locked with passwords and digital signatures.

Schools & Universities

Auto-fill report cards for every student by pulling grades straight from your gradebook. Generate the whole class in one click, password-protect and distribute them digitally or in print. Generate enrollment and registration forms, student progress reports and ID academic transcripts.

Human Resources

Easily generate employee onboarding packets, I-9, W-4, and state tax forms. Prepare W-9 forms, benefits enrollment forms, employment verification letters and direct deposit authorization forms.

Mailing labels & postcards

Turn a contact list into print-ready labels, personalized postcards, or booklets for every recipient. Built for direct mail campaigns, event invitations, real estate mailers, and nonprofit fundraising appeals.

Certificates & Diplomas

Issue thousands of personalized certificates with names, dates, and QR-coded verification links. Perfect for high schools, universities, and online course platforms issuing diplomas, degrees, or completion certificates at scale.

Tickets & Passes

Print and email event tickets with embedded QR or PDF417 codes generated from your registration list.


Excel spreadsheet data populating multiple PDF forms automatically

Features

Everything you need to generate PDF documents from data

Designed for accounting, HR, legal, insurance, and government teams who can't afford typos at scale.

Excel, CSV & databases

Pull from XLSX, CSV, Access, or any ODBC source — SQL Server, Oracle, MySQL, Postgres.

Multiple records per form

Place several data rows on one form — perfect for invoices with line items or rosters.

Combined output

Optionally save all merged documents into one PDF file instead of separate ones.

Images on the fly

Insert BMP, PNG, JPEG, TIFF, or even PDF stamps into any field.

QR & barcodes

Generate QR, PDF417, Code 39/128, and USPS IM barcodes from any data field — instantly scannable.

Per-recipient passwords

Each PDF can have its own open and permission passwords, pulled straight from the data file.

Digital signatures

Certify and digitally sign every output PDF to prove authenticity and tamper-evidence.

Email automation

Send via Outlook, Gmail, or SMTP with personalized messages and extra attachments per recipient.

Custom file naming

Build clear filenames like Invoice-3245-AcmeCo.pdf from any combination of fields and static text.

Watermarking

Personalize each document with a unique text watermark per recipient — like their name or ID — to trace any copy back to its source.

Command-line and scripting

Run unattended from BAT files or via Acrobat Guided Actions. Use Acrobat JavaScript for custom logic and behavior.

Processing logs

Each run logs timestamp, input file, output files, and settings — a full audit trail for troubleshooting.


Excel spreadsheet data populating multiple W-2 tax forms automatically

Connect any data source

If you have data, AutoMailMerge can fill PDFs with it.

Connect directly to spreadsheets and enterprise databases. Filter records with the built-in SQL, save query libraries, and re-run the same merge any time your data changes.

  • Microsoft Excel (.xlsx, .xls)
  • CSV / Tab-delimited
  • Microsoft Access (.mdb, .accdb)
  • SQL Server (ODBC)
  • Oracle/MySQL (ODBC)
  • XML Files

Security

Built for documents that have to be airtight

Per-document passwords

Unique open & permission passwords from data fields.

Digital signatures

Certify output PDFs with PKI-backed signatures.

Permission controls

Disable printing, copying, or editing on any output.

Flatten & lock

Make field values permanent and non-editable.

100% Local Processing

Every document is generated directly on your machine.

No Cloud Uploads

Your private data never leaves your computer.

No AI Training

No artificial intelligence models read, process, or learn from your information.

GDPR & HIPAA Ready

Complete local control ensures full compliance with strict privacy and medical data regulations.


Excel spreadsheet data populating multiple W-2 tax forms automatically

Data Privacy & Compliance

Government & Enterprise Compliance

Government Compliance & Security Verification

  • Approved Status: Officially vetted and cleared for deployment.
  • Vetting Agency: U.S. Department of Veterans Affairs (VA).
  • Architecture Standard: Approved for local desktop deployment under strict enterprise security architectures.
  • Official Registry: Verified as an enterprise-grade component for Adobe Acrobat automation workflows.
Verify Official Compliance Status on the VA TRM Registry

Enterprise & Government Vetting

  • Federal IT Standard Compliance: Pre-vetted under major Federal Acquisition Vehicles, including the NASA SEWP V network. Formally cleared for multi-department use across various municipal and state government procurement contracts.
  • Secure Infrastructure Mapping: Designed specifically for secure local networks where cloud-based data extraction is restricted.

Video & tutorials

Get Started Easily

One short demo, then step-by-step tutorials for every workflow.

Customers

Quietly powering document workflows since 2004

"Their easy-to-use and absolutely indispensable plugins are only bested by their stunningly fast and accurate customer support. I can honestly say this is the best customer support I have ever experienced. That is why I will keep coming back to Evermap."
Derek Heimlich
mpephelp.com
USA
"This has been the best tech support experience I have ever encountered. We truly appreciate the responsiveness, knowledge, accuracy and follow through. This experience will definitely make me recommend the program as well as cause me to search out other products offered by your company."
Grant D. Goldenberg, Esq.
Helms Mulliss & Wicker, PLLC.
Charlotte, NC
"I have been a customer of EverMap for several years and have found that their products deliver a high degree of quality for a nominal price. In addition, they have one of the best technical support teams in the industry. I have always received highly satisfactory responses in a very short time. I highly recommend this company."
Michael Fero
Assistant to the Treasurer
University of Washington
"I just purchased your pdf mail merge product. I was using another vendors product which expired when I found yours. I had my files merged and fixed within 1 hour. Thanks You Rock!"
Sharon Schmidt
The Honey Baked Ham Company
Detroit, USA
"I can't say enough about your products and more importantly your support. Honestly you have never disappointed me and you continue to add feature requests that are available within weeks of my request. EverMap has been the best money I have ever spent as a developer."
Chris Utter
CampSystems, Inc.
Merrimack, NH, USA
"We used to generate 4,000 monthly statements by hand. AutoMailMerge runs the whole batch in 12 minutes. It paid for itself the first week."
Sarah K.
Controller, mid-size CPA firm
USA

Online Reviews

Reddit and Adobe Forum Testimonials

Seamless Database & ODBC Integration

"AutoMailMerge is probably your closest match if you need a tool that does ODBC natively. You can embed the merge settings directly into the PDF template itself so the mapping travels with the form. "
Jason A.

Painless Excel and SQL Query Setup

"I use this software and the developer was very helpful in getting me started with it. I am doing some fairly advanced merges on an Excel document, and AutoMailMerge is an amazing plugin. I could not find anything else out there that does what it does by allowing me to create and run an SQL query on an Excel document. Setting up the mapping and actions with the tool made my complicated subscriber mailing task completely painless."
Adobe Forum Participant

Preservation of Editable Form Fields

"A lot of batch tools flatten the output so the recipient cannot type into it anymore, which depends entirely on whether the source was a real fillable form. If editability after delivery is a hard requirement for your document workflow, this plugin is an excellent choice. AutoMailMerge has a documented keep-form-fields option that prevents fields from being flattened. It ensures your fields survive the process intact so your recipients can still fill them out."
Maciej, Adobe Forum Expert

Clean Integration with Spreadsheet Data

"If you have forms, Acrobat can import data, fill fields, and save files using a paid Acrobat Pro plugin called AutoMailMerge. The plugin can read smoothly right from Excel spreadsheets to map the data out. I've looked at implementing custom code and using this plugin multiple times in my searches because it natively hooks into Excel tables to fill premade PDF templates."
Excel Subreddit Contributor

System requirements

What you need to run AutoMailMerge

Operating system

Windows 10, 11, Server 2012-2026.

Adobe Acrobat

Full Adobe® Acrobat® 9, X, XI, DC, or 2017–2026 (Standard or Pro), 32/64-bit.
Acrobat Reader is not supported.

FAQ

Common questions

Can I create PDFs from Excel spreadsheet without any coding?

Yes. AutoMailMerge lets you point at an Excel file, visually map columns to PDF form fields, and generate one PDF per single or multiple rows. No scripting, no macros, no developer required.

What versions of Adobe Acrobat I can use?

AutoMailMerge works with full versions of Adobe Acrobat (Standard or Pro) - 9, X, XI, DC, 2017-2026, Classic. Software does not work with free Acrobat Reader. Reader is not allowed by Adobe to generate new files. Both 32-bit and 64-bit versions of Adobe Acrobat are supported since introduction of 64-bit Adobe Acrobat in 2022. The software is for Windows OS.

Which data sources are supported?

Microsoft Excel (.xls, .xlsx), CSV, tab-delimited text files, Microsoft Access, and any ODBC-compliant database including SQL Server, Oracle, MySQL, and PostgreSQL.

Is my data safe?

Yes. PDF generation happens entirely on your machine — no data is sent to EverMap or any cloud service. Database connections go to databases you control. Emailing PDFs is optional and uses your own email provider, not EverMap's servers.

Can output PDFs be password-protected with individual passwords?

Yes. Each output PDF file can have its own password pulled directly from a data field, so every recipient gets a uniquely password-protected file.

Is it possible to put multiple data records into a single PDF?

Yes, it is possible to populate a single PDF form with data from multiple data records. The grouping happens by a value in the user-selected column. For example, all records that have the same invoice number in "Invoice" column can be placed int a single output PDF file.

Is it possible to put multiple data values into a single PDF form field?

Yes, it is possible to populate a single PDF form field with data from multiple data columns and any static text. For example, if there are [First Name] and [Last Name] data columns, it is possible to fill a single PDF form field with both values and separate them by a comma: [Last Name], [First Name].

Can I generate a single output PDF file with all forms inside?

Yes. You can choose to generate a single, combined PDF document that includes all copies of your populated forms.

Can I populate image fields in PDF forms?

Yes. You can dynamically personalize PDF files with different images based on data file. This functionality is used to create personalized product catalogs or real estate mailings.

Can the generated PDFs be emailed automatically?

Yes. AutoMailMerge can send each personalized PDF to the email address in your data file via SMTP, Gmail, or Microsoft Outlook, with customized subject lines and HTML message bodies.

Are the output PDF forms editable or locked?

You choose. Output PDFs can be left editable, flattened so fields become permanent, made read-only, password-protected per recipient, or digitally signed and certified.

Does it support QR codes and barcodes?

Yes. Generate QR, PDF417, Code 39, Code 128, and USPS Intelligent Mail barcodes on your PDFs from any data field — ideal for tickets, certificates, and tracking.

Can I automate the mail merge from a script?

Yes. Run mail merges from a command-line BAT file or via Adobe Acrobat's Guided Actions (Action Wizard) for scheduled, hands-free batch processing.

Can I add unique watermarks to each PDF?

Yes. You can add custom text as a watermark to each PDF file using your dynamic data pulled from one or more data columns.

Can I throttle emails to a specific rate to avoid being blocked for sending too many?

Yes. You can limit the number of emails sent per second to comply with your provider's rules.

Can I attach multiple files that are common to all email recipients?

Yes. You can attach files that are common to all recipients, as well as customize attachments for individual recipients.

Stop retyping. Start generating.

Join 50,000+ users who replaced manual PDF work with one well-mapped spreadsheet. One-time license, 2 years of maintenance, no subscription.

Perpetual license with 2 years of maintenance · Works with Adobe Acrobat Pro X, XI, DC - 2026