VBA Code to print specific pages on a PDF file based on a condition on the excel spreadsheet

LadyRave

New Member
Joined
Sep 14, 2016
Messages
41
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!
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,213,527
Messages
6,114,142
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top