VBA to create PDF from worksheet and attach to Outlook Email

[aglawrence]

Hi Everyone,

I am so close to solving this, but just one aspect does not work.

When I run the VBA/macro, it creates the PDF correctly and creates a new email, but the PDF is not attached. I think it is the line below in bold type which is causing the issue, but i can't seem to make it work.

Many thanks in advance to anyone who can help.

Andy

***I have attached the VBA code as a text file as the site won't let me add it directly into this post. Hope this is ok.***

[aglawrence]

Here is the attachment...

[aglawrence]

Here we go, second attempt with the attachment...