Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-05-2017, 11:50 AM
MyerSL MyerSL is offline Directory Merge: unwanted condensing of key data Windows XP Directory Merge: unwanted condensing of key data Office 2010 64bit
Novice
Directory Merge: unwanted condensing of key data
 
Join Date: Jun 2017
Posts: 2
MyerSL is on a distinguished road
Default Directory Merge: unwanted condensing of key data


I am merging a directory of admissions decisions made on students from various high schools, following MacroPod's wonderful tutorial. I have everything working as desired, EXCEPT for random records it is condensing all into one.

For example, schools A, B, C, and D all have their own page with the correct letter template (attached) and merged records. Then, out of the blue schools E and F are condensed (one letter listing students from BOTH schools--- merging in the address from only E and then throwing the students from F in at the bottom). It then gives G, H, and I their own separate pages but combines J, K, L, M, N.

The data source quite clearly has the data changing for the key record in the schools where it's merging them (unwanted) so I'm not sure where I've gone wrong. The data source is alphabetized by the school address (to avoid errors thinking 2 schools with the same name are the same school) and then by student last name for ease of use. Do I need to remove the 2nd level of sorting and ONLY sort by school address?
Attached Files
File Type: docx decision letter_public.docx (17.0 KB, 19 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Directory Merge: unwanted condensing of key data Condensing financial data H28Sailor Excel 13 04-02-2017 12:00 AM
Directory Merge: unwanted condensing of key data Mailmerge Directory - Incomplete Data Appearing in Merge Output Gwinnett Mail Merge 5 03-05-2017 02:24 PM
Directory Merge: unwanted condensing of key data Directory Mail Merge IslandAC Mail Merge 1 09-09-2016 04:53 PM
Directory Merge: unwanted condensing of key data Help with using catalog in Directory merge tarcher61 Mail Merge 15 03-30-2016 02:08 PM
Directory Merge: unwanted condensing of key data Word 2010 - directory mail merge - two separate group of data in one document htsu Mail Merge 2 03-07-2016 03:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 AM.


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