Mail Merge Using Excel Database.

[Guest]

I'm having problems using Excel Data that is being merged into my Word 2003
mail merge document. The data, mainly numbers, isn't coming over formatted
correctly (e.g. rather than $80,000, I get 80000). Any help would be good.

 

[Guest]

In your merge document, after inserting your merge fields, press Alt+F9 and
add the following to each field that produces a number:

\# $#,###.00

This will produce a currency format with 2 decimals, placing 2 zeroes to the
right of the decimal if there are only whole numbers.

When finished press Alt+F9 again

Happy typing...

 

[Guest]

Word doesn't like numerics in the merge data. Convert to strings and all will
work fine. Naturally you'll need to format the strings for proper presenation.

MS Word will require a format picture code on the merge field if a raw
numeric is passed. In addition Word can generate funky results if the raw
numeric value is passed to Word.

See: http://office.microsoft.com/en-us/assistance/HA011164951033.aspx

Abstract of URL shown above:
"Number formatting problems in a mail merge occur when the cells that
contain the numbers in the Excel worksheet are formatted as Number, Currency,
Date, Percentage, and so on. The solution for getting numbers to behave
properly when you merge is to format as Text the cells that contain numbers.
When cells are formatted as Text, you can type your numbers in the cells
exactly the way you want them to look (with dollar signs, zeros, and so
forth). Then they will merge exactly as you type them."

 

[Suzanne S. Barnhill]

See http://homepage.swissonline.ch/cindymeister/MM2002/MM2002.htm and
http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I'm having problems using Excel Data that is being merged into my Word 2003
mail merge document. The data, mainly numbers, isn't coming over formatted
correctly (e.g. rather than $80,000, I get 80000). Any help would be

good.