VBA code exporting to PDF but not attaching the file to the email.

Hi,

i am almost there with my code i am trying to PDF a range in excel and attach to an email. I am converting ok and opening up the email but i am missing the attachment and i am now stuck. I would really appreciate if someone could advise me how to adapt the code so it attaches just the range i have specified

Please Login or Register  to view this content.

Appreciate your help with this.

Hi Norie,

Thanks for your reply and that makes sense,. I have just noticed it is not saving the file, it is correctly opening up the range as a PDF along. i have checked the file name which is fine, must be something else in the code?

Hi Norie, when the pDF opens up the name is that of the file which is not what i want actually i want it to be the same as the email subject title.

Hi Norie


That is it, works perfectly. i will digest your comments now so i undertsand.

Thankyou so very much for looking at this and heping.

Hi

Is it possible to add Range ("d6) to the fn?

fn = "H:\XXX\XX\XX " & Format(Now(), "DD-MM-YYYY") & ".pdf"

Sorry one more thing how can i specify the sheet name, just in case another file is open it cannot accidently email the wrong sheet?

Hi i have worked out the filename :-)

Please Login or Register  to view this content.

Thanks