![]() |
|
#1
|
||||
|
||||
![]() The directory/catalogue merge tools won't combine multiple records into a single table cell. If you want that, you'll need to re-organise the source data, so that each record (i.e. 'box') has all its data on the same row, with different project, sample & date headers for each item. Either that, or you'll need to use a macro-driven process in Excel to automate & populate the Word document, without recourse to mailmerge.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
Thank you very much for your answer, Paul. I'm disappointed that I cannot do this through MailMerge but thank you for offering an alternative with a macro that could run in the Excel file to push the information to a label template in Word. I'm very familiar with creating and running macros in Excel but I don't have a lot of experience with cross-program code. I will look around the internet later for some examples, but do you have any examples of code or good resources in mind that will get me started down the right road?
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Mark J Rees | Mail Merge | 2 | 05-10-2013 06:00 PM |
![]() |
JohnFinNC | Mail Merge | 6 | 10-04-2012 06:36 PM |
![]() |
rohitjain80 | Mail Merge | 1 | 02-12-2012 03:42 AM |
Excel Multi Level Category labels | Spay | Excel | 0 | 03-14-2011 01:05 PM |
MailMerge Labels Question | trims30 | Mail Merge | 0 | 08-04-2010 05:21 PM |