Macro - PDF and Email

[CHUCKYNO999]

Hello - I have a Macro (shown below) to create PDF file and it saves the file in specific location shown in cell J2. Now, I'd like to be able to email this saved PDF file to an email entered in cell J3. Any guidance would be appeciated.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[Logit]

.

Please Login or Register  to view this content.

[CHUCKYNO999]

Thank you for the information. I combined both as you can see below, but it ends up creating the PDF file and opens an email ready to send but it doesn't attach the PDF file just created. The location of the PDF file is in column J.
How can I get the email to attach the just created file name from location in a specific cell? Thank you.

[Logit]

.
This is "suggestion code" that will require you edit to suit your current requirements :

Please Login or Register  to view this content.