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

[jonvanwyk]

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 "[email protected]"

Please Login or Register  to view this content.

[realniceguy5000]

Maybe this will help you Out?

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

...

[jonvanwyk]

@niceguy: Yea I found Ron's code through a Google search and have been trying to get it to work while waiting for help in this forum, but I have not been able to get it to work yet. Perhaps I should just post what I have come up with so far and get Ron's modified code critiqued here?

[jonvanwyk]

Based on the tutorials above, here is what I have put together so far. The code does not work and I get a "Compile error: Sub or Function not defined". Can anyone help?

Please Login or Register  to view this content.

[jonvanwyk]

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 [email protected].

Please Login or Register  to view this content.

[jonvanwyk]

I got the basic code to work, now just need to adapt it to my specific situation.