convert to pdf and then mail, using existing vba

Hi,
With lots of copy-paste, I finally have a system to e-mail an excel file. This is done using various sources, and now looks like this (I removed the lines which I think to be irrelevant) :

Please Login or Register  to view this content.

I understand that the way of working with the str_tmppath has the advantage that Outlook can easily find the file to attach :

Please Login or Register  to view this content.

I now would modify this in such a way that I send the file as a PDF file. How should I modify the codes ? I assume that I have to replace the last line in the first block.

Thanks a lot, I appreciate !