Hi,

I was hoping that somebody could assist with the following. Please see macro excerpt below which previously just renamed/saved the active workbook and attached it to Outlook mail if specified, no problem there.

I have been informed now however, that the document must issue in PDF format and have added the code in green below to create the necessary PDF file.

The issue is that the PDF clearly cannot be opened by Excel, and therefore cannot be specified as the active document to be attached to the mail. The excel document is continuing to be attached as one would expect.

I was hoping to find a workaround to this problem, is it possible to attach a third-party application document to an Outlook mail using an Excel VBA macro?

Many TIA.

Rgds
Orson.

Please Login or Register  to view this content.