Macro to attach excel pdf to email not working

[dantray02]

Hi,

Please can someone tell me when the following code will not attach a pdf of my workbook to an email:

Please Login or Register  to view this content.

It appears to do everything correct apart from attach the file.

Also - is it possible to have the pdf output to a temporary file location on the users computer and then clear down when the email has been sent? At the minute this is generating to the location the workbook is saved.

thanks in advance.

[TMS]

Looks like you are adding .pdf twice.

Regards, TMS

[dantray02]

hi - even with this removed it still doesn't work.

[jaslake]

Hi Dan

You need to fully qualify the FileName

Please Login or Register  to view this content.

Then you can use this line of Code to do this

is it possible to have the pdf output to a temporary file location on the users computer and then clear down when the email has been sent

Please Login or Register  to view this content.

Here's the Complete Code (from rondebruin) that I use

Please Login or Register  to view this content.