Mailmerge data from Excel into Word Document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CFO1969 - 31 Aug 2005 02:34 GMT

I am struggling with my new version of Word 2003. I have been doing
mailmerge for over 10 years, but I just updated to 2003 last week and now my
mailmerge documents are not importing dollar amounts into my Word Tables
correctly.

Example: In Excel the data cell might read 48.67 but in the Word Table is
will read 48.67000000001 or 48.671111111119

It appears to be a rounding interpretation problem or something, but I
checked all the formats in Excel and I have them all set to Number with 2
decimal places.

Shouldn't Word merge in the data exactly how it is in Excel? I have spent
hours on this! I was going to pay the $35 tech support fee to call but I am
afraid I will be supporting some customer service dept someplace oversees
like India or something and I don't want to do that.

Please HELP! Thanks!

Reply to this Message

Anne Troy - 31 Aug 2005 04:59 GMT

Try this, CFO:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
************
Anne Troy
www.OfficeArticles.com

>I am struggling with my new version of Word 2003. I have been doing
> mailmerge for over 10 years, but I just updated to 2003 last week and now
[quoted text clipped - 16 lines]
>
> Please HELP! Thanks!

Reply to this Message

Graham Mayor - 31 Aug 2005 05:15 GMT

See http://www.gmayor.com/formatting_word_fields.htm - while making this
transition, you will probably find
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm useful also.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I am struggling with my new version of Word 2003. I have been doing
> mailmerge for over 10 years, but I just updated to 2003 last week and
[quoted text clipped - 15 lines]
>
> Please HELP! Thanks!

Reply to this Message

Rate this thread: