Search results

I havent' figured it out yet. :) I'm still trying to figure out how to write the macro so it will automatically update the caption when the report opens. Thanks for the support!

Yes, If you change the caption on the report it will export as the caption name.pdf as well as load the pdf into outlook and send off to it's designated email address and/or sharepoint location. I tried it. Simply change the caption name on the report. Save the report. Then send as a...

Ohh...that's clever! I understand the code you wrote. Thank you. Although, I'm not familiar with VBA, I'll give it a shot. :) I aslo noticed that changing the caption on the report title will show up in the email as the "save as.pdf". Got any ideas of how to write a macro to change...

I currently have a report that works perfect. I have set up properties to convert the report to a pdf file and email it. Wonderful!!! My issue - I would like to rename the report to data in an underlying query prior to it converting to a pdf and sending it off. I don't want to change the...