[Mazzeree]

I use mail merge to produce 50 reports for different groups.

Each report contains thier current figures against a target. eg £0.65, 67%
3.12 etc.
The data in excel is formatted correctly but when I merge it, it loses all
format, currency, percentage, rounds up or dowm dependant on its mood and
sometimes gives me 10 decimal places.

This has only happened since I've been upgraded to XP.

Any help gratefully received.

Cheers

[Peter Jamieson]

Your best short-term bet is to change the connection method back to DDE (as
used by default in Word 97/2000): check Word Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to your Excel file
again, and select the DDE option when offered.

Longer term, you have to think in terms of using field formatting switches -
see Graham Mayor's pages at

http://www.gmayor.com/formatting_word_fields.htm

for further info.

Peter Jamieson

"Mazzeree" wrote in message
...
I use mail merge to produce 50 reports for different groups.

Each report contains thier current figures against a target. eg £0.65, 67%
3.12 etc.
The data in excel is formatted correctly but when I merge it, it loses all
format, currency, percentage, rounds up or dowm dependant on its mood and
sometimes gives me 10 decimal places.

This has only happened since I've been upgraded to XP.

Any help gratefully received.

Cheers

[Mazzeree]

Thanks Peter,

The short term solution worked a treat even though I have no idea what DDE
is?!?

Hopefully this will sort me out as the 'longer term solutions' seem a little
beyond me at present.

Many Thanks

"Peter Jamieson" wrote:

Your best short-term bet is to change the connection method back to DDE (as
used by default in Word 97/2000): check Word Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to your Excel file
again, and select the DDE option when offered.

Longer term, you have to think in terms of using field formatting switches -
see Graham Mayor's pages at

http://www.gmayor.com/formatting_word_fields.htm

for further info.

Peter Jamieson

"Mazzeree" wrote in message
...
I use mail merge to produce 50 reports for different groups.

Each report contains thier current figures against a target. eg £0.65, 67%
3.12 etc.
The data in excel is formatted correctly but when I merge it, it loses all
format, currency, percentage, rounds up or dowm dependant on its mood and
sometimes gives me 10 decimal places.

This has only happened since I've been upgraded to XP.

Any help gratefully received.

Cheers

[Peter Jamieson]

FWIW, Word (and other Windows software) has various ways to connect to other
programs and to get data from "databases". One of the oldest of them is DDE
(it stands for "Dynamic Data Exchange"), which was the default method used
by Word for Excel connections until Word 2000. DDE was "deprecated" (i.e. in
effect, declared obsolescent) a very long time ago and although its
replacements (the current default is called "OLEDB") could in theory do a
better job, in practice the Excel OLEDB "provider" does not work as well as
the DDE method in some ways. On the other hand, DDE doesn't do some things
that OLEDB does.

A lot of people have no problems with DDE.

Peter Jamieson
"Mazzeree" wrote in message
...
Thanks Peter,

The short term solution worked a treat even though I have no idea what DDE
is?!?

Hopefully this will sort me out as the 'longer term solutions' seem a
little
beyond me at present.

Many Thanks

"Peter Jamieson" wrote:

Your best short-term bet is to change the connection method back to DDE
(as
used by default in Word 97/2000): check Word
Tools|Options|General|"Confirm
conversion at open", go through the process of connecting to your Excel
file
again, and select the DDE option when offered.

Longer term, you have to think in terms of using field formatting
switches -
see Graham Mayor's pages at

http://www.gmayor.com/formatting_word_fields.htm

for further info.

Peter Jamieson

"Mazzeree" wrote in message
...
I use mail merge to produce 50 reports for different groups.

Each report contains thier current figures against a target. eg £0.65,
67%
3.12 etc.
The data in excel is formatted correctly but when I merge it, it loses
all
format, currency, percentage, rounds up or dowm dependant on its mood
and
sometimes gives me 10 decimal places.

This has only happened since I've been upgraded to XP.

Any help gratefully received.

Cheers