print crystal report in vba

[oh704]

Hi All,

I've set up a crystal report template (version 12) to create custom letter for each record in an access table. in the pass there werent that many records to handle so i just manually select the record in crystal report's report filter and print to pdf.

But now there's a big batch of letters that needs to be printed. Does anyone have some quick and dirty vba code that loops through a table, pass the record to the CR template as recordsource and prints a pdf doc for each record?

Thanks, please help this project is on a very tight deadline.
any help is much appreciated.