I have a mailmerge document using an Excel spreadsheet. In one field called LVMass (a number) I wish to do two things at the same time. Both can be done separately (and the examples below both work), but the question is can I combine both at the same time?

1. Format the number to two decimal places using:

\# "0.00"



2. Set to bold if outside a range:

{={MERGEFIELD LVMass}-201 \#"'{MERGEFIELD LVMass}';'{MERGEFIELD LVMass}'"}

I have tried various ways to combine these without success. Is this possible?

Thank you for any advice you can give.

bigukfan -

Give this a shot... Works for me in my document anyway. Had to read between the lines a bit so hope I interpreted what you need correctly.

Assuming that you want to format all values as 2 digit decimal - Then
to bold any LVMass value that is less than 200.

{if {condition } < 200 {true_result} {false_result}}

The formula would be:



{if {MERGEFIELD LVMass} < 200 {MERGEFIELD LVMass \# "0.00"} {MERGEFIELD LVMass \# "0.00"}}

Note that you have to put the picture switch in for both the true and false
results to have all the values display with decimals. Also note that you have to insert the curly brackets - {} - using CTRL-F9 key combination. You can't just type them in.

The bold formatting was applied after the whole formula was input using the bold key (CTRL-b)

Hope that is what you needed!

Scott

Thanks for your help ScottA, some very useful comments from you.

In further research it turns out formatting in Excel can be preserved in Word by connecting using DDE, which is a whole lot less hastle! A couple of clicks to specify DDE in Word and the rounding problem is not a problem anymore.

More than one way to skin a cat as usual. Once again, thank you for your comments.

Hi bigUKfan,

Although DDE can preserve formatting, it's also a whole lot less capable than the default OLE DB provider Word 2002 & later use. For starters, with an Excel data source, it only works with the first worksheet and won't accept named ranges. The use of field switches also means your mailmerge output can be independent of the data format. Without that, you'd need have separate fields in the data source for every data format you wanted to use.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]