Font Changes When Data is Merged

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ben Schaum - 30 Oct 2006 22:31 GMT

I have data stored in an Excel spreadsheet that I am merging into a Word
document. My Word document is in Human Light Cond font, as is the code for
the Mergefield. Then, when I actually merge the data, the font of the merged
field changes to Human Black Cond. I can highlight the data and change the
font to Human Light Cond, but it does not preserve the font when I merge the
data. The following is an example of the code:

{ MERGEFIELD EndPremiumChange \* MERGEFORMAT } where EndPremiumChange is my
variable from Excel.

Appreciate any help,

Reply to this Message

macropod - 31 Oct 2006 01:42 GMT

Hi Ben,

This sounds like you may have 'hard formatted' the characters in the Human
Light Cond font, but the paragraph style uses the Human Black Cond font. If
so, correcting the paragraph style should solve the problem.

Alternatively, select the 'M' in 'MERGEFIELD' and format that in the Human
Light Cond font and change the '\* MERGEFORMAT' switch to '\* CHARFORMAT'.

Cheers

Signature

macropod
[MVP - Microsoft Word]

> I have data stored in an Excel spreadsheet that I am merging into a Word
> document. My Word document is in Human Light Cond font, as is the code for
[quoted text clipped - 7 lines]
>
> Appreciate any help,

Reply to this Message

Ben Schaum - 31 Oct 2006 15:40 GMT

Could you please explain how I would correct the paragraph style?

Thanks,

> Hi Ben,
>
[quoted text clipped - 23 lines]
> >
> > Appreciate any help,

Reply to this Message

Doug Robbins - Word MVP - 31 Oct 2006 19:47 GMT

Select the end of paragraph mark (¶) and then from the Format menu, select
Style, then click on Modify and then on Format and select Font.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Could you please explain how I would correct the paragraph style?
>
[quoted text clipped - 34 lines]
>> >
>> > Appreciate any help,

Reply to this Message