Consulting

Results 1 to 2 of 2

Thread: Macro to Save Outlook Email Body and Attachments as One Single PDF & Print

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Question Macro to Save Outlook Email Body and Attachments as One Single PDF & Print

    Hi,

    I was hoping I can get some help with a vba macro that will be saving a selected outlook email into a PDF, but with the PDF including the message body 1st and then after all attachments of various extensions in the same PDF.
    Then have that Single PDF that includes all that, automatically printed as One Document to a specific printer. It will be Virtual Printer, and that printer requires it to be One Document, not multiple.

    Sending the resulting PDF to print successfully will be the final action of the macro.

    Any help will be greatly appreciated.

    Thank you.

  2. #2
    VBAX Mentor
    Joined
    Nov 2022
    Location
    The Great Land
    Posts
    308
    Location
    I think would have to save the email message as PDF (never tried that), save each PDF attachment, then use Adobe automation code to merge the multiple PDF's into one (I have done this).

    Controlling PDF print has been asked numerous times. Here is one discussion https://stackoverflow.com/questions/...files-with-vba
    How to attach file: How to upload your attachments (vbaexpress.com) To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •