Jenny hall wrote:
[Quoted Text] > 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?
Use a conditional field eg
{IF {Mergefield fieldname} <> "" "{Mergefield fieldname}" " " }
> 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.
You could try:
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. (In Word
2007 it is Office Button > Word Options > Advanced > General > Confirm file
format conversion on open). Then when you attach the data source to the mail
merge main document, you will be given the option of using the DDE method of
connection which should read the data as you have it formatted in the table.
or use a formatting switch on the field -
http://www.gmayor.com/formatting_word_fields.htm
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
|