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,
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,
I think this is a reason:
Formula:Please Login or Register to view this content.
but here in RDB_Mail_PDF_Outlook function:
you try to attached file from cl.Value not FileNamePlease Login or Register to view this content.
but I can be wrong.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
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,
Last edited by callumlmcgrath; 05-09-2019 at 04:22 AM.
1. Did you check that file is successfully saved in:
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 itPlease Login or Register to view this content.
3. add
Please Login or Register to view this content.
in both macros and check that everything is correct with path and name of file.Please Login or Register to view this content.
EDIT: sorted FileName has not contains path.
Check attached file.
Last edited by KOKOSEK; 05-09-2019 at 05:10 AM.
YES!! Thank you so much. It worked after point 2 so thank you very much
You welcome.
Thanks for rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks