I have an Access DB containing details for around 100 x single page specification documents.
I need a simple program that will grab each sheet's data from the DB and create a separate formatted spec sheet in Word for it, so when the program is run it generates 100 (or however many there are) Word docs at once.
This "program" can be a VB macro or a Win32 app.
I would also need a "master" Word document template that I can then enter data into manually and save as a regular Word document.
I hope this explains what I want well enough, if not I'll add more information here.