Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2021, 07:27 AM
helenc helenc is offline data lost in merge Windows XP data lost in merge Office 2019
Novice
data lost in merge
 
Join Date: Jun 2021
Posts: 4
helenc is on a distinguished road
Default data lost in merge

I am prepping a merge with over 500 items so I separated four out and am trying to get them right before I format the whole thing . After two days I am finally at a point where I can get the pictures to show up, but I have hit a wall I cannot seem to get over.



The data is in an Excel database. The first column should have a book cover and the second column has title, author, publication information, etc. I have six merge fields in that column.

The first of the five items comes in fine. The second image shows up with the data for the third book. The next image shows up with no book data and there is no data or image for anything else.

Why isn't it finding and merging all my data? What do I need to do next?
Attached Images
File Type: jpg rawdata.jpg (74.7 KB, 9 views)
File Type: jpg as merged.jpg (75.5 KB, 9 views)
Reply With Quote
  #2  
Old 06-22-2021, 03:49 PM
macropod's Avatar
macropod macropod is offline data lost in merge Windows 10 data lost in merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Delete the double quotes from your Excel workbook. If you really need something that looks like double quotes in the output, use paired single quotes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-23-2021, 06:47 AM
helenc helenc is offline data lost in merge Windows XP data lost in merge Office 2019
Novice
data lost in merge
 
Join Date: Jun 2021
Posts: 4
helenc is on a distinguished road
Default Thanks, but did not help

They were not necessary, just something I had not cleaned up yet. Mass deleted all the quotes out of the doc and re-ran the merge with the same results.

I tried rearranging them to see if it was something in the lines, but I still get three images and two narratives, only the first set matches. That leads me to believe it is something in the command sequencing.
Attached Images
File Type: jpg test2.jpg (120.0 KB, 11 views)
Reply With Quote
  #4  
Old 06-23-2021, 02:35 PM
macropod's Avatar
macropod macropod is offline data lost in merge Windows 10 data lost in merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Without actually seeing the mailmerge main document and some representative data, it can be difficult for anyone to diagnose the issue. Can you attach the mailmerge main document and a workbook to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 06-24-2021, 08:30 AM
helenc helenc is offline data lost in merge Windows XP data lost in merge Office 2019
Novice
data lost in merge
 
Join Date: Jun 2021
Posts: 4
helenc is on a distinguished road
Default

I appreciate your time. Here are some files. There are six items in this one. .csv is not an allowed file type so I included the .xlsx, but I did use a .csv for my attempt. (To be honest, I have tried it both ways, neither with much success)

The cover with no name on it goes with A Witch Shall Be Born. That is the second cover on the list but the third item for the merge. The next two the covers and book info are one off, then they just stop.

Thanks again, Helen

2 HOURS LATER: I realized I had not removed the quotation marks from the sample I sent so I did and reran it with the same failed results. That is not the issue.
Attached Files
File Type: xlsx CSVhowardBooks.xlsx (11.0 KB, 6 views)
File Type: docx csvbeforemerge.docx (14.4 KB, 8 views)
File Type: docx csvaftermerge.docx (136.3 KB, 5 views)
Reply With Quote
  #6  
Old 06-24-2021, 04:19 PM
macropod's Avatar
macropod macropod is offline data lost in merge Windows 10 data lost in merge Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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
  #7  
Old 06-26-2021, 09:30 AM
helenc helenc is offline data lost in merge Windows XP data lost in merge Office 2019
Novice
data lost in merge
 
Join Date: Jun 2021
Posts: 4
helenc is on a distinguished road
Default

Directory did the trick. It worked great for the six items I tested with. Now to add the other 500....

Thanks, Helen
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Lost data inside MS Word files (but files not lost) Elaxx Windows 0 12-12-2020 07:19 AM
data lost in merge Lost some data from excel 2016 lakshi Excel 1 04-15-2018 12:42 PM
lost data boellsclown OneNote 1 07-03-2015 07:15 AM
data lost in merge lost data after incorrect merge changes response vthomeschoolmom Word 1 04-22-2012 04:08 PM
Power cut and Skydrive, lost data alexb123 Office 0 08-30-2010 02:55 PM

Other Forums: Access Forums

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


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