Alan, You can do this in VBA code. Are you at least somewhat familiar with VBA? You can loop through either your recordset or I believe the pages of your report and export them to a different file name that you create dynamically if you like. James -----Original Message----- From: Alan Forster [mailto:Alan.Forster@xxxxxxxxxxx] Sent: Monday, October 13, 2003 3:12 AM To: mso@xxxxxxxxxxxxx Subject: [mso] PrintToFile in Access 2000 :VSMail mx2 Hello, I am trying to create a report that includes a large number of photographs (>1000, 12 per page). Due to the size of the report I have to create a single page at a time and print it then go to the next page. I can create the files by sitting and typing in the filename etc in to the print dialog box. In Excel the PrintOut action has a parameter PrintToFilename and the associated one PrtFilename. I can not find a similar parameter in the Access PrintOut action. Is there another way of automatically printing to file and seting the filename in VBA code? Thanks, Alan. The information in this e-mail is confidential and intended to be solely for the use of the addressee(s) and may contain copyright and/or legally privileged information. If you are not the addressee (or responsible for delivery of the message to the addressee) please e-mail us at postmaster@xxxxxxxxxxx and delete the message from your computer; copying, distribution, use or disclosure of its contents is strictly prohibited. As Internet communications are capable of data corruption no responsibility is accepted for changes made to this message after it was sent. For this reason it may be inappropriate to rely on advice contained in any e-mail without obtaining written confirmation of it. In addition, no liability or responsibility is accepted for viruses and it is your responsibility to scan attachments (if any). Please note that for business purposes, outgoing and incoming emails from and to the company may be monitored and recorded. Mouchel Consulting Ltd, Registered Office : West Hall, Parvis Road, West Byfleet, Surrey UK KT14 6EZ Registered No : 1686040 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************