Mail merge: merging number from excel to word.

[Guest]

I have number colum like this 5.98 (in excel sources).And I merge this colum
to word and I have problem when I use mail merge like this 5.982222222222222.

How should I set it for keep 5.98 in word file?

 

[Graham Mayor]

I have number colum like this 5.98 (in excel sources).And I merge
this colum to word and I have problem when I use mail merge like this
5.982222222222222.

How should I set it for keep 5.98 in word file?

With a numeric formatting switch -
http://www.gmayor.com/formatting_word_fields.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Guest]

Hi,

the problem you've described occurs because mail merge by default uses ole
db connection. The problem and its solution is described in KB article
http://support.microsoft.com/kb/320473/en-us.

Regards,
Nika Lampe

 

[Graham Mayor]

The DDE connection method (which is how Word used to connect to its data
before Word 2002) will correct this issue and is mentioned on the linked web
page in question, but a formatting switch on the field is quicker and easier
to implement.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>