Thread: [Solved] data lost in merge
View Single Post
 
Old 06-24-2021, 04:19 PM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Your workbook still has double-quotes - in column Q.

Your table also has too many «Next Record» fields, which is why the images and data don't align. It also explains why you're getting some of the other errors. I suggest deleting all rows except the first row and running the merge as a Directory merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote