![]() |
|
#5
|
|||
|
|||
|
Thanks, Macropod, for the clarification.
I did a test of your suggestion and found that it worked well. The merge output contained all the text and none of the records in the groups were truncated. A couple of notes, 1. How to create a record that contains more than 255 characters? I used Word to create placeholder text (=Rand(1,4)) that ensured I would have sufficient text for the dummy record. See attached. 2. At first, I entered the dummy data in the first cell of the first column (Section) in the Excel sheet. That placement did not result in the proper output. I still had truncated cells in the output tables. I am guessing that is because my merge code uses Key 1 (Mergefield Section) to group the records. Because my merge code uses Col A header as my Key 1 (Section), the placeholder text was appearing in the Key 1 mergefield and Key 2 mergefield (Question). See thread above for the merge code that I used. 3. When I put the placeholder text in the Key 2 (Question) field, the merge output was correct. See attached. Inserting a dummy record in the first row of the Excel sheet is certainly easier than connecting to DDE files. Cheers, |
| Tags |
| incomplete data, mailmerge, tables |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Mailmerge Directory - TableJoiner Macro
|
Gwinnett | Mail Merge | 3 | 03-01-2017 09:25 AM |
Word 2010 - directory mail merge - two separate group of data in one document
|
htsu | Mail Merge | 2 | 03-07-2016 03:10 PM |
| Directory MailMerge with Category Grouped Lists on Labels | screech | Mail Merge | 3 | 06-18-2014 11:41 PM |
Pictorial directory using mailmerge
|
JohnFinNC | Mail Merge | 6 | 10-04-2012 06:36 PM |
Directory Mailmerge
|
rohitjain80 | Mail Merge | 1 | 02-12-2012 03:42 AM |