View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Suzanne C Suzanne C is offline
external usenet poster
 
Posts: 1
Default Telling Word to pick a mailmerge field from three options

Hopefully someone can help me with this. I have three fields for a date:
DATEFIELD1, DATEFIELD2, and DATEFIELD3. Every line of data pulling from my
database has the same date in these fields. However, each instance is
differnt as to if the date will be populated in DATEFIELD1, DATEFIELD2, and
DATEFIELD3, or it could be in all three fields. I only need the date to be
displayed once and thought that I could use an IF field to do so, however,
I'm having problems. Does anyone know of a way to tell Word to display
DATEFIELD1 unless blank, then display DATEFIELD2 unless blank, then display
DATEFIELD3