EXCEL VBA MACRO TO email SHEET AS PDF ATTACHMENT

[Youseepooo]

I want to do as the title states.
Print a certain range as pdf and send as attachment with a choice of a body.
Can someone help me ?


Thanks
YM

 

[DanteAmor]

This worked perfectly, thank you!

Again with pleasure. Thanks for the feedback