Mail Merge formatting

[Sam Horwood]

Dear All,
I'm using a word XP (2002) mail merge document with an
ODBC connection to an excel spreadsheet, because that's
the only connection that works properly, and I needs some
advice on formatting for a single field. As ODBC brings
in the raw data with no formatting, I have to format the
field "street number" which should be easy enough, only
if you try to use the switch \# "0" it displays the
fields with the values "Unit 4 / 74" as "", because these
are strings, not decimals. If you take the switch out,
this still occurs, but the normal street number values
like "43" come through as "43.0". I was wondering if
there was a switch that would force the ODBC connection
to bring through all of the data as text, rather than
only bringing through the decimal values.
My sincere thanks in advance
Sam

 

[Graham Mayor]

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Sam,

You need to format the data as text in Excel

--
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