Mail Merge formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sam Horwood - 19 Feb 2004 01:47 GMT

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

Reply to this Message

Graham Mayor - 19 Feb 2004 06:49 GMT

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

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail gmayor@mvps.org
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Dear All,
> I'm using a word XP (2002) mail merge document with an
[quoted text clipped - 13 lines]
> My sincere thanks in advance
> Sam

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 22 Feb 2004 04:01 GMT

Sam,

You need to format the data as text in Excel

Signature

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

> Dear All,
> I'm using a word XP (2002) mail merge document with an
[quoted text clipped - 13 lines]
> My sincere thanks in advance
> Sam

Reply to this Message