Recent content by Gkmorr

myPath = "Shared Folder\sAttachmentName\" DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, myPath & sAttachmentName Cronk - I was playing around with what you had suggested and got it to work with taking out the "sAttachmentName" after myPath so it shows as: myPath = "Shared Folder\"...

Try myPath = "Shared Folder\sAttachmentName\" DoCmd.OutputTo acOutputReport, stDocName, acFormatPDF, myPath & sAttachmentName Cronk - when I tried your suggestion I am not able to Output at all. I get a Run-time error '2501': The OutputTo action was cancelled. Any other suggestions

Update***- the above code States outputting 'Test File #1' which is what I want but the file name is saving as sAttachmentNamesAttachmentName.pdf

OK I am now able to export to a shared folder after sending the email. Thanks for the suggestion. Now I am running into getting the output to save as a different name as the report name. I have tried a few things and cannot get the file to name as Agent Name & Survey # as I have stated...

Hey everyone, need some help here. I have created the following code for emailing a survey (with a custom name) and then saving to a specified folder on a shared drive. There is no issue when emailing the report however I cannot get the file to save with a custom name in the shared folder. I...

Hey everyone, my name is George and am based in the US (Ohio). Do DB work daily but wont say I am an expert by any means. Sometimes fumble through so I may ask some questions Thanks