print form to pdf with custom file name per page

[matt beamish]

Hi people. I have written a database that holds membership records, and I have a form that writes a letter to select members with content governed by their member records. I can print this to pdf and create a tidy multipage document. What I really want to do, is print to pdf as separate pages with [ID fields] used to generate each file name.
Can anyone tell me how to do this?
Thanks in advance
Matt, Leicester, UK

 

[apr pillai]

Hope this will help you: Saving Report Pages as separate pdf files

 

[matt beamish]

Dear Apr Pillai,
thank you for replying to my post. I have tried using the method you have advised, but not been too successful. I think this is because I am not experienced enough with VBA, and I am not patient enough (and do not have sufficient time at the moment) to use the Northwind samples, and work from first principles.

When I have a bit more time, I will have another go. As a workaround, I will print as a multiple page pdf, and then extract my pages and rename manually.

thanks again

Matt

 

[matt beamish]

Well I did have to print each page manually, and it took me a long long time. As my VBA is only slowly improving, would someone possibly help me on how to integrate my record source and what I am trying to do, with the code in Apr Pillai's function, which is here

http://msaccesstips.com/2012/01/saving-report-pages-as-separate-pdf-files/

I really would like to master this method, as I never want to have to manually print and save with custom file names again.
thanks
Matt