Convert to PDF, Save to Network Drive, AND/OR attach PDF to an email (Automatically)

I am using the code below attached to a "Submit Request" button that converts the file into a PDF and then automtically saves it to a folder on the network drive. Depending on if other cells are "true", I need the converted PDF to be emailed instead of saved when other cells are "true" such as:

E7 = TRUE AND E17 OR E18 OR E19 OR E20 = TRUE, then email .pdf to "person1@email.com"

Please Login or Register  to view this content.

Maybe this will help you Out?

http://www.rondebruin.nl/pdf.htm

...

The code below reflects what I am using to automatically create and save a pdf with conditional naming of the file on a network drive depending on which boxes are checked in a list. However, some individuals who may be checked are not able to access the network. In this instance, I need for the created PDF to be attached to an email with a predetermined email address using the same macro button.

I have been referred to http://www.rondebruin.nl/pdf.htm but have been unable to come up with something that works. Any help in modifying the code below is greatly appreciated!

For instance, if A52 = TRUE and A60 = TRUE, then create PDF based on the same naming scheme [Cells(2, 2).Value & " - " & Cells(6, 2).Value & ".pdf"] and attach the PDF to an email, and automatically email it to johndoe@email.com.

Please Login or Register  to view this content.