Font Changes When Data is Merged

[Ben Schaum]

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,

 

[macropod]

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

 

[Ben Schaum]

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

Thanks,

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

--
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
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,

 

[Doug Robbins - Word MVP]

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.

--
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?

Thanks,

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

--
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
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,