Mail Merge issues- skipping data

Question

I am having a mail merge issue from Excel. I cleaned the data, checked for formulas, check for reciprocle data connections and found nothing. The mail merge is skipping half of the data source for merging envelopes. The data source is formated as GENERAL. Can this be an issue and if so why is it printing some and not others?

The person running the merge INSISTS the data is corupt, even though I cannot find it. Am I missing something?

PLEASE PLEASE HELP.

Thank you

Answer 1

You haven't told us whether there is anything different about the records not being merged. If those records contain double-quote characters in any field, that could explain what you're seeing.

Having double quotes in any field in a mailmerge data source - even if that field isn't referenced in the mailmerge main document - is liable to result in an incomplete or corrupt output. You can have single quotes, however and, if you pair those single quotes, they will approximate the appearance of double quotes. That can be achieved via a simple Find/Replace in the data source.

Answer 2

If you execute the merge to a new document by using the Edit Individual Documents destination, does the resulting document contain an envelope for each record? If it does, you might just print that document.

Answer 3

If you execute the merge to a new document by using the Edit Individual Documents destination, does the resulting document contain an envelope for each record? If it does, you might just print that document.

Answer 4

No. I only get an envelope for half of the entries selected (6 out of 12)

Answer 5

The Excell data sheet contains up to 250 individual names with addresses. It will periodically skip entries, only printing about half. But this does not happen on every data sheet which are all formated the same. For example: I will have 10 individual Excel sheets with up to 250 names on each sheet. Sheet 1 will print complete, but sheet 2 will skip data. Sheet 3-6 will print complete but sheet 7 will skip data.

I am at a loss as this seems to be sparatic. I cannot find a pattern. It does not seem to be a glitch in the Word Mail Merge and I cannot find coruption within the Excel sheet. I am missing something.

Your thoughts would be appriciated.