Automate MSG to PDF Conversion Using Acrobat and Excel VBA
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.

- 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.
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.
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.
Launch Adobe Acrobat Pro, click on the 'Tools' tab at the top, and select 'Action Wizard' from the Customize section.
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.
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.
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.

Automate via Excel VBA and Acrobat API
For highly complex or conditional large-scale automation, Excel VBA can be used to control the Acrobat API to process MSG files.
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. Open WPS PDF: Launch WPS Office and click on the 'PDF' tab from the home workspace.
- 2. Access Batch Tools: Click on 'Batch PDF' or 'Create PDF' from the toolbar to import multiple files at once.
- 3. Merge Documents: Select the 'Merge PDF' tool to combine your newly converted documents into a single, organized PDF file.
- 4. Export and Save: Adjust your output settings, arrange the page order, and click 'Merge' to finalize your document.

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.




