View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jenny hall Jenny hall is offline
external usenet poster
 
Posts: 2
Default make mailmerge leave blanks when fields are empty

Mailmerge kindly moves fields together when there are blanks (like in a short
address). Does anyone know how to stop this so the balnks are retained?

Also, does anyone know how to ensure that a field defined in Excel as text,
but containing mainly numbers, is treated by Word as text. At the moment, it
seems to treat this data as numeric, and represents any fields containing
non-numerics as 0. Only way round this at the moment is to ensure that the
first entry contains a non-numeric.