Unwanted bolding in merge using Word/Excel 2000

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tremaline@invalid.domain - 13 Apr 2005 16:33 GMT

I'm using a mail merge from an Excel 2000 spreadsheet into a Word 2000
document. The document's first stuff at all is merge fields (for
name, address, city, state, zip - nothing unusual). Nothing in the
document, and nothing in the .xls file, are bolded. But when I do the
merge, the resultant document has all those first things (name,
address,etc.) bolded. The other merge fields in the document merge
fine, formatted or not formatted as I like.

Why the unwanted bolding? How do I eliminate it (short of manually
editing the merged document, something I'm loathe to do)?

Reply to this Message

Peter Jamieson - 13 Apr 2005 22:31 GMT

The easiest way to eliminate it is probably to use Alt-F9 to reveal the
field codes and change e.g.

{ MERGEFIELD name }

to

{ MERGEFIELD name \*Charformat }

and ensure that the space before the M, and the M of "MERGEFORMAT", are not
formatted as bold. Do the same for all the offending MERGEFIELD fields.

If the fields are currently like

{ MERGEFIELD name \*Mergeformat }

it may be enough just to remove the \*Mergeformat. Otherwise, change
\*Mergeformat to \*Charformat and proceed as above.

Peter Jamieson

> I'm using a mail merge from an Excel 2000 spreadsheet into a Word 2000
> document. The document's first stuff at all is merge fields (for
[quoted text clipped - 6 lines]
> Why the unwanted bolding? How do I eliminate it (short of manually
> editing the merged document, something I'm loathe to do)?

Reply to this Message