MailMerge with Excel AlphaNumeric data

[New Sun]

When merging Word document with data in an Excel file,
any field (Column) that contains a number (Numeric) in
some records (Rows) and has a text (AlphaNumeric) in
other records, those records which have the AlphaNumeric
data will not merge in the document, Word will print a O
(ZERO) instead of the merge data !??!

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

In Excel, format the cells in the column as Text

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP

 

[Cindy M -WordMVP-]

Hi New,

Doug's answer is correct, as far as it goes. The problem is
that most people try to use the Format/Cell command to
format as text, usually without much success. You need to
select the column, then use Data/Text to columns to format
the column explicitly as text at the database level.

When merging Word document with data in an Excel file,
any field (Column) that contains a number (Numeric) in
some records (Rows) and has a text (AlphaNumeric) in
other records, those records which have the AlphaNumeric
data will not merge in the document, Word will print a O
(ZERO) instead of the merge data !??!

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

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