Skip to main content
U
us s24607169
Participant
February 27, 2020
Question

VBA to convert external file to PDF

  • February 27, 2020
  • 1 reply
  • 1270 views

I have several thousand .msg files that need to be converted to a PDF via an automated EXCELprocess. I am on the latest Acrobat DC. In the Windows Explorer context menu when I right-click on a .msg file there is the option to "Convert to Adobe PDF" so I know the functionality exists somewhere. I want to be able to automate the conversion of each .msg file to PDF so that I can merge the PDF with another PDF that I am creating as part of the process. So far within EXCEL thhe creation of the second PDF and merge of the 2 PDF's I'm testing with I have working. I'ts just being able to perform the conversion of the .msg file that I need help with. Several hours of searching before posting this has come up empty.

TIA

This topic has been closed for replies.

1 reply

Meenakshi_Negi
Meenakshi_Negi
Legend
February 28, 2020

Hi there, 

 

As you are trying to convert multiple .msg file to PDF, you may try that using the action wizard. You can create a custom action to create and combine PDFs using the wizard.

For more details, please refer to the following link:

-  https://helpx.adobe.com/in/acrobat/using/action-wizard-acrobat-pro.html

Check if that helps.

 

Let us know if you have any questions or if you are referring to something else.

 

Regards,

Meenakshi

U
us s24607169Author
Participant
February 28, 2020

Unfortunately That won't work. I must be able to accomplish it in VBA. I have thousands of .msg files that must be moved into our document storage system with a header document appended to them. I have VBA code that scans the fileserver to gather the filenames and code to create the header pdf and append /merge it to a test pdf. My open issue is needing the ability to convert a .msg file to a pdf with Adobe calls within the VBA code.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices