Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

VBA to convert external file to PDF

New Here ,
Feb 27, 2020 Feb 27, 2020

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

TOPICS
Create PDFs , Edit and convert PDFs , How to
1.3K
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Feb 27, 2020 Feb 27, 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

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Feb 28, 2020 Feb 28, 2020
LATEST

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.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines