Thank you for your reply. I have not used the approach you mentioned, is it possible to write a little more pseudo code for me? At the moment I am using a macro to loop through the clients Then I draw data from five separate tables for each client – move to the next client, etc. The recipients of the report insist each of the five tables have a different format (colour, font) so it is easier for them to delineate. The whole report ends up as a large pdf. Cheers
... View more