Don't preview. It's a bug that happens often enough as to not ever trust it.
Main issue now is that the mere previewing of the merge can corrupt your merge document. Close down ID. Restart ID. Do the merge without previewing it and trust it will happen. Then carefully review the merged document for errors. If there are errors, you'll need to create a new document, copy over your elements from the corrupted document, do the merge without previewing and check it carefully.
If it is still breaking the merge, let us know. At that time, screen shots of the CSV, the layout in ID, the merge panel, etc., might be needed.
Thanks very much for your swift response Mike.
I've closed and restarted ID, reopened my template and merged without previewing in any way, but my merged document is still showing errors. Do I need to start from scratch rather than using my saved template? That'd be a pain since it took me a while to get my formatting right.
I also tried opening a new document and pasting my template into that - ran the merge but errors still occurring.
Without reviewing the data, tis hard to say. If it is still broken in a new document, then I would begin by reviewing the data in a good text editor, mainly looking for line breaks (soft returns or hard returns).
Take and begin a new document. Don't copy any thing over, just bring in the CSV (I use tab delimited to avoid some issues with comma delimiters). Put the fields into a new text box, don't worry about layout. Do the merge.
If it is breaking in the same place, then the data is likely "broken" by either of the above possibilities.
I've just viewed the data in text form and it's a mess...I can see why it's going so wrong now! I did as you said and created the merge unformatted and it's still showing the same errors, so it must be the data itself.
Thanks for all your help, at least I know what's going on now. Looks like I've got a lot of work ahead of me!
If you want/need advice on fixing it, I would need to see the Excel file. So if you would like to go that route, just send me an email or PM by going to my account (click on my name).
Best regards, Mike