Open Outlook from InfoPath and attach PDF
Posted on 2011-03-11
I have an Infopath from that is published to a Sharepoint site. The form is filled out by the employee and after completing it they click a button that exports it to a PDF. The PDF is saved to another document library on sharepoint and all done using VB Script.
The forms (PDF format) are then accessed by another employee which then attaches it an email template and sends it off to our customers.
I am trying to eliminate this step. At the moment the employee converts the InfoPath form to a PDF, I would like to:
1) Create a button that opens an Outlook Template stored in Sharepoint
2) Attaches the newly created PDF
Currently I have a field in the Infopath form that uses the concat function to create the file name, extension, and path for the PDF. Simply put, I need to take the value from that fields to locate the PDF to attach all using VB. Any help would be much appreciated. Thank you