Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-07-2017, 02:41 AM
gmayor's Avatar
gmayor gmayor is offline Directory Merge: unwanted condensing of key data Windows 10 Directory Merge: unwanted condensing of key data Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,144
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

That doesn't sound good. I thought for one horrible moment that I had upset the filtering during some major updates recently, but I have tested again and that doesn't appear to be the case.

Click reset and when you start again the Default is not to use the filter. Use that default option. Just add the folder to save the documents.

If it still doesn't work, send me your workbook to supportATgmayor.com, putting your forum username in the subject (or it will be discarded). By all means anonymize the data. I am not interested in your data, just the worksheet, so I can establish if there is a problem.

If you are unable to do that, copy and paste only the used data range to a new Workbook, starting at Cell A1. Sort the data by the schools, then use that new workbook as your data source for the merge. There must be no empty fields in the schools column.

Which Word version are you using?

Incidentally did you try sorting the data and using your original merge document without recourse to the add-in?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
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:55 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