Hello,

May someone please help me generate a code to do the following.

I have a spreadsheet that has a list of customer names and their filing method. Depending on the filing method, the code will open up an external PDF document corresponding with the customer and either print that specific page out, email the PDF document via outlook, or attach the PDF to another existing document. Please note that all customer documents are in ONE PDF file.

For example -

Customer Name: Filing Method:

Mikasa Mail (these will be printed)
Eren Email (email via outlook)
Goku WebPortal (attach to an existing document)

How do I create a code in excel to perform this task? Each customer will have their own dedicated page in the PDF file that entails all their information.

I appreciate the help!