#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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] |
#5
|
|||
|
|||
Hi Paul,
will this work for a 4 line table? Thanks Huw |
#6
|
||||
|
||||
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] |
Tags |
merge data from access |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge from Access DB | jmo | Word VBA | 0 | 12-21-2015 12:32 PM |
Mail Merge - Many to One w/MS Access data | mklepper | Word | 1 | 03-07-2015 08:30 AM |
MS Access 2007 query to Merge | KenshiroUK | Mail Merge | 1 | 02-11-2013 04:31 PM |
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 |