PDF to Outlook

[callumlmcgrath]

Hey,

I have a macro that will save a pdf from a pivot table and open a new outlook e-mail, however I'm having trouble getting it to upload the pdf to the e-mail.

Can anyone help please?

I've attached the doc for help.

Thanks,

[KOKOSEK]

I think this is a reason:

Please Login or Register  to view this content.

but here in RDB_Mail_PDF_Outlook function:

Please Login or Register  to view this content.

you try to attached file from cl.Value not FileName
but I can be wrong.

[callumlmcgrath]

Hey Kokosek,

I think because I have -

FileName = cl.Value & ".pdf"

this should work, however I did change it to include PathName, and also put it in the same format as in RDB_Mail_PDF_Outlook however this didn't work either

If you have any other ideas I'm all ears.

Thanks,

[KOKOSEK]

1. Did you check that file is successfully saved in:

Please Login or Register  to view this content.

2. Change this:

Please Login or Register  to view this content.

into this:

Please Login or Register  to view this content.

if you pass parameter use it
3. add

Please Login or Register  to view this content.

Please Login or Register  to view this content.

in both macros and check that everything is correct with path and name of file.

EDIT: sorted FileName has not contains path.
Check attached file.

[callumlmcgrath]

YES!! Thank you so much. It worked after point 2 so thank you very much

[KOKOSEK]

You welcome.
Thanks for rep.