Hi everyone,
I'm pulling my hair out here and wondered if someone might be able to help.
I'm putting together a little directory for our organization, using data from
an Excel spreadsheet to do a mail merge. There's a few conditional
statements in it to detemrine if a spouse name should be printed, or their
email, etc. which is all working just fine.
Except, when I merge the document, a lot of records are missing. Like close
to 1/2. The kicker is that they appear when the "preview results" under the
mailing tab is on, but not in a merged-to-edit document.
I tried redoing the merge in a different document with just a simple address
block wondering if some of the conditionals were setup wrong and throwing it
off, but the same thing happens with just a plain-jane merge.
The only thing determining whether they should be printed or not is an X in
a "directory" column in the spreadsheet, no fancy rules in that regard.
tl;dr Records appear in a preview but not in the final document.
Thanks for the help!