View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
daroga daroga is offline
external usenet poster
 
Posts: 5
Default Mail merge records in Preview but not in Final Merge (2007)

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!