merging from excel to word

[marla]

Our department uses word to send out letters to our
customers. These letters contain dollar amounts and
percentages along with normal address information. We use
Excel to set up the data, then merge information into our
form letter in word. When the merge is performed, all
formatting (i.e. decimals, commas, etc... in the numeric
information) is lost. In addition, the program adds
additional zeros or 9's to the data. As a result we have
been printing the data out of excel and using it as a
guide to manually fix each mistake. We are using Office
2000. We had other office programs before and never had
this problem. Any ideas?

 

[Greg]

Marla,

I am not sure if this will help, but have a look at the
material on Excel data here in Graham Mayor's article on
merging:
http://www.gmayor.dsl.pipex.com/mail_merge_labels_with_word
_xp.htm

Graham uses long links and it is broken here by text
wrapping. Be sure to type or paste the entire link in
your browser.

 

[Cindy Meister -WordMVP-]

Hi Marla,

I assume you meant to write you have Word 2002, not 2000?

See the information on Word 2002, connection methods and
foramtting on my website. Even if you have Word 2000, the
information should help you.

Our department uses word to send out letters to our
customers. These letters contain dollar amounts and
percentages along with normal address information. We use
Excel to set up the data, then merge information into our
form letter in word. When the merge is performed, all
formatting (i.e. decimals, commas, etc... in the numeric
information) is lost. In addition, the program adds
additional zeros or 9's to the data. As a result we have
been printing the data out of excel and using it as a
guide to manually fix each mistake. We are using Office
2000. We had other office programs before and never had
this problem.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail