Creating multiple sheets from data table/ Excel solution to Word's mailing list?

[davorperic]

Hello everyone!

I have a question I've been trying to find a solution to for a while now.
I work in a construction company where we have many template contracts to prepare and print for various subjects with their respected info (address, contact person, type of work, sum etc.)
Once I discovered I could connect my access or excel database of clients to Word's mailing list where I select fields in the contract template it made my life so much easier.

Now, I have a situation where I need to make multiple bills of quantities based on a template where the data (headings info, type of works, quantity, price) would be connected to a table/database with all the rows containing BOQ info.

Basically, just like the mailing list in Word just this time I don't need .doc files I need excel sheets.

So far I understood I have to make a sheet template that would be created with a VBA Macro command, but I didn't find anywhere how to make multiple sheets based on each row from a certain table/database.

Any help to get me started would be much appreciated.

Thanks to everyone in advance!