Exporting report to seperate files

[lithuanian98]

Is there a way to export a report from Access and save each page in the
report as a seperate file and the file name of the report is what is in
say the customer field? I have a report that generates a page for each
customer but I want to save each page of the report to a seperate file
and the name of the file has to be based on the customer's name and
maybe include the date in the name. Example: joes crab shack 12 2006.?
The format could be Word, PDF, HTML and use a template for HTML.

 

[Larry Linson]

Is there a way to export a report from Access and
save each page in the report as a seperate file and
the file name of the report is what is in say the
customer field? I have a report that generates a page
for each customer but I want to save each page of
the report to a seperate file and the name of the file
has to be based on the customer's name and maybe
include the date in the name. Example: joes crab shack 12 2006.?
The format could be Word, PDF, HTML and use a template for HTML.

I think saving in HTML will give you a file-per-page, but it doesn't have
the flexibility to name them as you describe. Instead, you can write VBA
code to read them, obtain the customer's name from the HTML page (which,
after all, is text with markup), and the NAME statement to rename the file.

Larry Linson
Microsoft Access MVP