unintended bolding in merged data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stuart Harden - 21 Mar 2007 16:04 GMT

I have merge document with xls source where one field is presented bolded,
and is not in the xls or word merge document formatted as bold until
automatically done once data is merged.

In all other merge fields, the merge text, i.e.

<bold>State</bold> «HomeState»
<bold>Zip Code</bold> «HomeZip»

yet displays as:

<bold>State</bold> GA
<bold>Zip Code 31564</bold>

Of course all this is in word and excel, so, my html above is just for
clarification of display sake.

No matter what change I make, the merged numerical zip code is bolded. I
have removed all bolding from the xls file, confirmed that the cell in
question is not bolded in the word template, nothing changes.

I suppose the "start over" troubleshooting technique would be the next step,
but, if anyone is aware of a simpler "fix", it would be greatly appreciated.

Regards-
Stuart

Reply to this Message

Graham Mayor - 21 Mar 2007 16:19 GMT

Add a charformat switch to the merge field (in place of the mergeformat
switch if present) and it will adopt the formatting of the text used for the
field.
http://www.gmayor.com/formatting_word_fields.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have merge document with xls source where one field is presented
> bolded, and is not in the xls or word merge document formatted as
[quoted text clipped - 22 lines]
> Regards-
> Stuart

Reply to this Message

Stuart Harden - 21 Mar 2007 17:44 GMT

Much Appreciated, exactly what I needed.

Stuart

> Add a charformat switch to the merge field (in place of the mergeformat
> switch if present) and it will adopt the formatting of the text used for
[quoted text clipped - 27 lines]
>> Regards-
>> Stuart

Reply to this Message