Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 03-03-2017, 12:38 PM
Gwinnett Gwinnett is offline Mailmerge Directory - Incomplete Data Appearing in Merge Output Windows 7 64bit Mailmerge Directory - Incomplete Data Appearing in Merge Output Office 2013
Novice
Mailmerge Directory - Incomplete Data Appearing in Merge Output
 
Join Date: Feb 2017
Posts: 5
Gwinnett is on a distinguished road
Default

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,
Attached Images
File Type: png =Rand(1,4).PNG (36.1 KB, 30 views)
File Type: png Mailmerge FAQs Excel DumbRec.PNG (30.2 KB, 29 views)
File Type: png Mailmerge FAQs Placeholder DumbRec.PNG (36.3 KB, 30 views)
Reply With Quote
 

Tags
incomplete data, mailmerge, tables



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge Directory - Incomplete Data Appearing in Merge Output Mailmerge Directory - TableJoiner Macro Gwinnett Mail Merge 3 03-01-2017 09:25 AM
Mailmerge Directory - Incomplete Data Appearing in Merge Output 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
Mailmerge Directory - Incomplete Data Appearing in Merge Output Pictorial directory using mailmerge JohnFinNC Mail Merge 6 10-04-2012 06:36 PM
Mailmerge Directory - Incomplete Data Appearing in Merge Output Directory Mailmerge rohitjain80 Mail Merge 1 02-12-2012 03:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:44 PM.


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