Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-08-2022, 06:26 PM
The Fatman The Fatman is offline Merge Data from Access Windows 7 64bit Merge Data from Access Office 2010 64bit
Novice
Merge Data from Access
 
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
  #2  
Old 03-08-2022, 07:06 PM
macropod's Avatar
macropod macropod is offline Merge Data from Access Windows 10 Merge Data from Access Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Have you tried a label merge in Word? All you need do for that is:
1. select an appropriate label type
2. configure the first label
3. choose 'update labels'
4. Run the merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-09-2022, 08:02 PM
The Fatman The Fatman is offline Merge Data from Access Windows 7 64bit Merge Data from Access Office 2010 64bit
Novice
Merge Data from Access
 
Join Date: Mar 2014
Posts: 4
The Fatman is on a distinguished road
Default

Hi Paul,

that is a part of the problem. Sometime ago I could specify a label siz and no per page but now they are all fixed and I haven't found a way around that. Please point in the the right direction.

Thanks

Huw
Reply With Quote
  #4  
Old 03-09-2022, 08:26 PM
macropod's Avatar
macropod macropod is offline Merge Data from Access Windows 10 Merge Data from Access Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could simply choose Mailings>Start Mail Merge> Labels>
• Choose an appropriate label layout;
• New Label, then complete the label details; or
• Cancel, then insert a two-row table on the page with the required positioning and dimensions.
From there on, the process is the same as for any other label merge. There has been little change in the last 15 years.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 03-15-2022, 10:01 PM
The Fatman The Fatman is offline Merge Data from Access Windows 7 64bit Merge Data from Access Office 2010 64bit
Novice
Merge Data from Access
 
Join Date: Mar 2014
Posts: 4
The Fatman is on a distinguished road
Default

Hi Paul,

will this work for a 4 line table?

Thanks

Huw
Reply With Quote
  #6  
Old 03-16-2022, 12:36 AM
macropod's Avatar
macropod macropod is offline Merge Data from Access Windows 10 Merge Data from Access Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What works really depends on your database structure. A DATABASE field in a Word document may be the way to go. An outline of this approach can be found at:
https://answers.microsoft.com/en-us/...f-8642e46fa103
For some working examples, see:
https://www.msofficeforums.com/mail-...-multiple.html
https://www.msofficeforums.com/mail-...tml#post151706
Merge excel list into Word Receipt
(the second of these uses a macro to apply some additional formatting).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
merge data from access

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge from Access DB jmo Word VBA 0 12-21-2015 12:32 PM
Merge Data from Access Mail Merge - Many to One w/MS Access data mklepper Word 1 03-07-2015 08:30 AM
Merge Data from Access MS Access 2007 query to Merge KenshiroUK Mail Merge 1 02-11-2013 04:31 PM
Merge Data from Access Merge from Access linked to a SQL View Mark J Rees Mail Merge 5 05-19-2011 02:53 PM
Word / Access - Mail Merge ibuilders Mail Merge 0 07-30-2007 06:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft