Thread: [Solved] Merge Data from Access
View Single Post
 
Old 03-08-2022, 06:26 PM
The Fatman The Fatman is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Mar 2014
Posts: 4
The Fatman is on a distinguished road
Default 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!
Reply With Quote