Save selected range in a pdf format & email the file to a someone automatically?

Hi guys,

Below is what i am currently using on my worksheet to save a selected cell range then automatically email it to my clients. It works fine but I want to review the file and also sometimes I want to write something more in the email I am sending to clients using the code below.

So, there are two things I want to achieve here, if someone can rewirte or add anything to the code given below to make what I want to happen, I will be highly appreciated.

First, I want to save the selected range of cells in a pdf format to the following path:
"C:/User/Jin/Desktop/DDD"

Second, I still want the automated email function to remain active but do not send emails out before I click send button (like how we normally send emails using outlook).

Can anyone help??
Thanks

Please Login or Register  to view this content.

Thank you Sean and Patel. It works perfect. And Patel, the link is very useful, just what I was looking for.