PDF Conversion Issues

Automate MSG to PDF Conversion Using Acrobat and Excel VBA

John WilsonJohn Wilson Nov 2, 2026 872 views

Question details

The user wants to automate the process of converting thousands of Outlook MSG files to PDF format and combining them with other PDF documents.

Automate MSG to PDF Conversion Using Acrobat and Excel VBA
Product
Adobe Acrobat Pro / Microsoft Excel VBA
Device & OS
not provided
Scenario
Batch converting and merging a massive volume of email files (MSG) into consolidated PDF documents using an automated workflow.
Observed behavior
Needs an automated, bulk-processing solution to convert and combine MSG files into PDFs without manual intervention for each file.
Before you start

Ensure you have Adobe Acrobat Pro installed, as the standard version of Acrobat does not include the Action Wizard required for advanced batch processing workflows.

Solution 1Recommended

Use Acrobat Pro Action Wizard for Batch Conversion

Adobe Acrobat Pro's Action Wizard allows you to build a custom automated workflow to convert and combine multiple files into PDFs without writing code.

The Action Wizard provides a visual interface to string together multiple commands. This is highly effective for converting a folder full of MSG files and merging them with existing PDF documents.

1
Open Action Wizard

Launch Adobe Acrobat Pro, click on the 'Tools' tab at the top, and select 'Action Wizard' from the Customize section.

2
Create a New Action

Click on 'New Action' in the Action Wizard toolbar. In the 'Files to be Processed' section, choose 'Add Folder' and select the directory containing your MSG files.

3
Add Combine Step

From the 'Choose tools to add' pane on the left, expand the 'Pages' or 'Files and Folders' category and add the 'Combine Files' step to your action sequence.

4
Save and Run

Save the action with a recognizable name like 'MSG to PDF Batch'. Click on your new action in the Action Wizard list and press 'Start' to begin the automated conversion and combining process.

Use Acrobat Pro Action Wizard for Batch Conversion
Acrobat Pro Exclusive: The Action Wizard feature is only available in Adobe Acrobat Pro. If you are using Acrobat Standard or the free Acrobat Reader, this option will not be visible.
Efficient PDF Management

Batch Convert and Merge Documents with WPS Office

If you are looking for an easier way to handle multiple document conversions without dealing with complex VBA scripts, WPS Office offers a comprehensive, built-in PDF toolkit to convert and combine files effortlessly.

  1. 1. Open WPS PDF: Launch WPS Office and click on the 'PDF' tab from the home workspace.
  2. 2. Access Batch Tools: Click on 'Batch PDF' or 'Create PDF' from the toolbar to import multiple files at once.
  3. 3. Merge Documents: Select the 'Merge PDF' tool to combine your newly converted documents into a single, organized PDF file.
  4. 4. Export and Save: Adjust your output settings, arrange the page order, and click 'Merge' to finalize your document.
Seamlessly compatible with Microsoft Office formats (Word, Excel, PowerPoint)Built-in Batch PDF conversion and merging toolsLightweight application that won't bog down your system resourcesIntuitive interface that requires zero programming knowledge
microsoft office alternative - wps office

Frequently Asked Questions

Can I use Acrobat Standard for batch converting MSG files?

No, the Action Wizard feature required to set up batch conversion workflows is exclusively available in Adobe Acrobat Pro. Acrobat Standard does not include this functionality.

Why is my VBA script failing to convert MSG files to PDF?

VBA scripts typically fail if the Adobe Acrobat Type Library or Outlook Object Library is not enabled in the VBA References, or if the specific Acrobat API commands you are calling have been deprecated or blocked by security settings.

Is there a limit to how many files Acrobat Action Wizard can process at once?

While there isn't a strict hard limit, processing thousands of files simultaneously can consume significant RAM and cause the application to crash. It is recommended to batch the files in smaller groups of 500 to 1,000 files.

Does WPS Office support VBA for automating conversions?

WPS Office supports Macros and VBA scripting in its Premium versions. However, interacting with third-party software APIs like Outlook via macros functions differently. For standard document-to-PDF conversions, utilizing the built-in Batch PDF tool in WPS is highly recommended.