Using Excel values in Word Mail Merge
 

Hi all,

I'm trying to use the rounded values in an excel spreadsheet as fields in my
mail merge. The merge pulls up the original number with many decimal places.
How do I get the merge to show the rounded value?

Thanks for your help!

Dory

Using Excel values in Word Mail Merge
 

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

dory a wrote:

Hi all,

I'm trying to use the rounded values in an excel spreadsheet as fields in my
mail merge. The merge pulls up the original number with many decimal places.
How do I get the merge to show the rounded value?

Thanks for your help!

Dory

--

Dave Peterson

Using Excel values in Word Mail Merge
 

In article , wrote:
Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

It's not cheating, it's an alternative way of doing something. :)
I've had format problems when mail merging before. Fixed them by choosing
the ...
MS Excel worksheets via DDE (*.xls)
option when getting the data. Suddenly, I got what I expected again.

HTH

Using Excel values in Word Mail Merge
 

Thank you Dave and Bruce. It worked great!!!!

"Dave Peterson" wrote:

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions he

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

==========
I often cheat instead of racking my brain.

I'll insert another column (probably hidden!) and use:
=text(a2,"ddmmyy")
or
=text(a2,"mm:ss.0")
or
=text(a2,"00000")
(or whatever format I want)
and use that field in the mailmerge.

(Cheating doesn't bother me anymore <vbg.)

dory a wrote:

Hi all,

I'm trying to use the rounded values in an excel spreadsheet as fields in my
mail merge. The merge pulls up the original number with many decimal places.
How do I get the merge to show the rounded value?

Thanks for your help!

Dory

--

Dave Peterson