Mail Merge - Bulk Document Generator

PDF4me Mail Merge with Data String action generates multiple personalized documents from templates in Power Automate using structured data arrays. This powerful bulk document generation feature processes data from various collection sources, transforming dynamic data into Word or PDF documents through mail merge, supporting both array and object JSON structures for flexible data mapping across Microsoft 365 workflows.

Authenticating Your API Request

To access the PDF4me Web API through Power Automate, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Power Automate flows and PDF4me's powerful mail merge services.

Get your API Key

Key Features

• Bulk Document Generation: Create multiple documents from single template
• Data List Processing: Process arrays of data for individual document generation
• Template Support: Use Word (.docx) or PDF templates with merge fields
• Flexible Data Formats: Support JSON array and object structures
• Output Array: Receive all generated documents as processable array

Parameters

Complete list of parameters for the Mail Merge with Data String List of Docs action. Configure these parameters to control mail merge processing.

Important: Parameters marked with an asterisk (***) are required and must be provided for the action to function correctly.

Parameter	Type	Description	Example
Template File Data***	Binary	Template File Content • Map template file from source location • Supports .docx and .pdf file formats only • Template should contain merge fields • Can be from SharePoint or OneDrive	[Template Content]
Template File Name***	String	Template Name • Template file name with proper extension • Must be .docx or .pdf • Used for processing identification • Supports dynamic naming	LetterTemplate.docx
Data String***	String	Merge Data Collection • Dynamic data values for merging with template • JSON array format: [["Field1","Field2"],["Value1","Value2"]] • JSON object format: [{"Field1":"Value1"},{"Field2":"Value2"}] • Each array item generates one document	[["Name","Email"],["John","[email protected]"]]

Output

The PDF4me Mail Merge with Data String List of Docs action returns comprehensive output data for seamless Power Automate flow integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
Output Documents	Array of Objects	Array of generated documents, automatically iterable in flows
File Content	Binary	Binary content of each generated document
File Name	String	File name of each generated document

JSON

JSON Response Format

{
  "Output Documents": [
    {
      "File Content": "[Binary Content]",
      "File Name": "Letter_001.pdf"
    },
    {
      "File Content": "[Binary Content]",
      "File Name": "Letter_002.pdf"
    }
  ]
}

Flow Integration

Power Automate Flow Usage

Use generated documents array in subsequent actions:

• Apply to Each: Iterate through documents for individual processing
• Email Distribution: Send each document to respective recipient
• SharePoint Upload: Save all documents to library in batch
• OneDrive Storage: Store documents in organized folders
• Individual Processing: Process each generated document separately
• Zip Creation: Combine documents into downloadable archive

Workflow Examples

The PDF4me Mail Merge with Data String List of Docs action in Power Automate provides comprehensive workflow templates designed for real-world business scenarios:

Customer Letters

Automated Personalized Customer Letter Generation

Transform customer communications with automated mail merge:

Complete Workflow Steps:

1. Trigger: Marketing campaign approved for execution
2. Get Customer List: Query CRM for target customer segment
3. Format Data Array: Create JSON array with customer names and data
4. Get Letter Template: Fetch letter template with merge fields
5. Generate Letters: Create personalized letter for each customer
6. Apply to Each: Process each generated letter
7. Email Customer: Send personalized letter to each recipient
8. Archive Letters: Store all generated letters in SharePoint

Business Benefits:

• Generates 500+ personalized letters per campaign
• Increases response rates by 45% with personalization
• Eliminates manual letter creation
• Reduces campaign launch time from 2 days to 2 hours

Create Flow

Certificate Generation

Automated Bulk Certificate Generation Workflow

Streamline certification with automated certificate mail merge:

Complete Workflow Steps:

1. Trigger: Training course completed by all participants
2. Get Participant List: Retrieve all course completers from LMS
3. Format JSON: Create array with name, course, date for each
4. Get Certificate Template: Fetch certificate template
5. Generate Certificates: Create certificate for each participant
6. Apply to Each: Process each generated certificate
7. Email Participants: Send certificate to each student
8. Archive Certificates: Store all issued certificates

Business Benefits:

• Generates 200+ certificates per course automatically
• Provides instant certificate delivery upon completion
• Eliminates manual certificate creation
• Reduces issuance time from 1 week to 10 minutes

Create Flow

Tax Documents

Automated Tax Document Bulk Generation

Optimize tax processing with automated document generation:

Complete Workflow Steps:

1. Trigger: Tax year end - scheduled trigger January 15th
2. Get Client Data: Query accounting system for all clients
3. Format Tax Data: Create JSON array with tax details per client
4. Get Tax Template: Fetch tax summary template
5. Generate Tax Docs: Create personalized tax document for each
6. Apply to Each: Process each tax document
7. Email Clients: Send tax summary to each client
8. Archive Tax Docs: Store all documents for compliance

Business Benefits:

• Generates 1000+ tax documents annually in one run
• Eliminates manual tax document creation
• Reduces preparation time from 1 week to 1 hour
• Ensures consistent tax document formatting

Create Flow

Offer Letters

Automated Offer Letter Bulk Generation

Enhance hiring with automated personalized offer letter creation:

Complete Workflow Steps:

1. Trigger: Hiring manager approves candidates for offers
2. Get Candidate List: Retrieve approved candidates from ATS
3. Format Offer Data: Create JSON with name, role, salary per candidate
4. Get Offer Template: Fetch employment offer letter template
5. Generate Offers: Create personalized offer for each candidate
6. Apply to Each: Process each offer letter
7. Email HR: Send offers to HR for review and sending
8. Archive Offers: Store all offer letters securely

Business Benefits:

• Generates 50+ offer letters monthly automatically
• Personalizes each offer with candidate-specific details
• Reduces offer creation time from 30 minutes to 2 minutes each
• Accelerates hiring process by eliminating offer preparation delays

Create Flow

Industry Use Cases & Applications

Human Resources & Payroll

Human Resources & Payroll Use Cases

• Offer Letters: Generate personalized employment offers in bulk
• Onboarding Documents: Create new hire paperwork for all employees
• Performance Reviews: Generate review documents for all staff
• Benefits Statements: Create personalized benefits summaries

Finance & Banking

Finance & Banking Use Cases

• Account Statements: Generate statements for all customers
• Tax Documents: Create tax summaries for all clients
• Investment Reports: Generate portfolio reports for investors
• Notice Letters: Create account notices for customers

Education & Training

Education & Training Use Cases

• Certificates: Generate completion certificates for all students
• Report Cards: Create progress reports for all learners
• Transcripts: Generate transcripts for graduating students
• Parent Letters: Create personalized parent communications

Marketing & Communications

Marketing & Communications Use Cases

• Campaign Letters: Generate personalized marketing letters
• Customer Notices: Create service update notifications
• Event Invitations: Generate personalized event invites
• Thank You Letters: Create appreciation letters for customers

Get Help

PDF4me ConnectGet your API KeyPower Automate Documentation