I want to produce a series of long reports, each of about 50 pages in WORD, much dependent on figures and text contained in an Access 2003 database. All the reports are basically the same, differing only according to the text in various rows in the database. I want to automate the production of the reports as much as possible. Currently I divide the main report into sections and use VBA to produce an Access report for each section. I then export the sections in Rich Text Format, open them in WORD and cut and paste into the main report. This takes forever, particularly as I have to do a lot of reformatting in WORD. I have over 200 of these to do - There must be a better way!! Any ideas much appreciated.

You don't really give much detail about what the reports are like. Would a Mail Merge be appropriate?

Take a look at Albert Kallal's Super Easy Word Merge.

Thanks for this. I've been playing about with it and it will make things a lot easier