Merge Data from Access
Hi,
I have an access database (easier to use than excel for this due to column arrangement) with:
Asset
Supplier Co (et al)
Installer
Contact - General
Contact - Emergency
I have a word document where, thus far, I have:
Assets: «Asset»
Supplier Company and Address: «Supplier_Co_and_Add»
Installer: «Installer»
Contact - General: «Contact__General»
Contact - Emergency: «Contact__Emergency»
Assets: «Next Record»«Asset»
Supplier Company and Address: «Next Record»«Supplier_Co_and_Add»
Installer: «Next Record»«Installer»
Contact - General: «Next Record»«Contact__General»
Contact - Emergency: «Next Record»«Contact__Emergency»
What I am trying to do, or not have to do, is copy the second table 280+ times so I get one label per asset in Access (283). At one time it was easy to lie to word or access and say label x*y (x height/Ywidth) with n per A4 page and then merge the data now it looks as if that can't be done!
|