Hello, please can someone identify the bug in the following code. it is supposed to export a selection of the worbook to a pdf in the workbook folder, and attach the file to an email, generating to/cc/subject/email dialogue. which it does.
it is also supposed to attach the file to the email, which is doesn't.
Any advise help or suggestions greatly appreciated.
thanks,
Please Login or Register to view this content.
Shouldn't you be passing sFilename instead of Filename to the RDB_Mail_PDF_Outlook2 function?
Please Login or Register to view this content.
If posting code please use code tags, see here.
hi, no - this doesn't work either.
thanks,
What exactly did you change?
Have you tried stepping through the code with F8?
Have you checked where the PDF is being saved to?
Last edited by Norie; 01-29-2014 at 09:30 AM.
hello, i changed 'filename's to 'sfilename'. other than that I don't really know what to check for.
the pdf is being saved to the location the workbook is saved.
I have tried to step through it but it does just that, it steps through to the end where it generates the email but without the attachment.
thanks.
Are you sure that's where the PDF is saved to?
You don't actually specify the path anywhere here.
Please Login or Register to view this content.
that's where it is going - does it not go there by default?
thanks,
dan.
Dan
It goes to whatever directory is active at the time, which could be the same as the workbook.
However you aren't including the path when passing the filename to the function either, so that could be a problem.
oh right, i'm new to this so am prone to errors.
How do I specify the output to be the location where the workbook is saved? I will give that a try.
any ideas? thanks agian,
Try this.
Please Login or Register to view this content.
no this still doesn't work... is the file location not something to do with this:
which then incorporates here:Please Login or Register to view this content.
thanks.Please Login or Register to view this content.
That's what I added, it wasn't in the original code.
jesus, sorry mate. is it because it's not included in the attachments bit:
Please Login or Register to view this content.
sFilename doesn't belong there, the filename of the attachment is passed to the function as the argument FileName.
Any chance you could upload a sample workbook?Please Login or Register to view this content.
Then I could test the code, which I've not been able to do because I've not been able to recreate the setup you have.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks