Quote Originally Posted by globetrot
Thx xCav8r, but the RTF export doesnt retain drawn lines which I have used to separate columns in the report. The problem with GaryB's method is that you still have to specify a filename to PDF it to when you print.
That's why I favor merging with Word to create reports over using Access Reports and exporting them to RTF. Reports are meant to be shared, and although Access Reports can be exported in a variety of formats, each has their disadvantages. Printing to PDF is the only alternative when you want to share your reports electronically, but that's not always as desireable as a Word doc.

It seems to me that you have three options. First, you can create a Document Template in Word with which to merge your data. You can automate the merge, file name, and PDF creation from Access. Second, you can export the report to RTF and automate Word to reinsert the graphical elements you lost on conversion to RTF; then you can send to your PDF printer, naming your file in accordance with your invoice number, if you haven't already done so, and storing your file in a location that is not your PDF output directory (if you're using Adobe and worried about overwrites). Third, you can do as I suggested in my previous post, which is send your report to your PDF printer, wait for the output, grab the file, rename it, and move it as desired.