Merging Number vs labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PCOR - 11 Feb 2004 18:58 GMT

Hi
I am merging an Excel database into a MS word document.
The Excel database consists of Name/Street No/ Street name/City
in the case where the street number is a number like 1243 or 345 or 567899,
all is ok
BUT if the street number is #312-24 or 5567A then the merge document shows a
0(zero) as the street number
Can any one tell me how to fix that proble. Much appreciated
Thanks

Signature

Norton Professional 2004 says this email is clean...believe it

Reply to this Message

Cindy M -WordMVP- - 11 Feb 2004 21:15 GMT

Hi Pcor,

> I am merging an Excel database into a MS word document.
> The Excel database consists of Name/Street No/ Street name/City
> in the case where the street number is a number like 1243 or 345 or 567899,
> all is ok
> BUT if the street number is #312-24 or 5567A then the merge document shows a
> 0(zero) as the street number

I take it this is Word 2002 or 2003?

This is due to how you're connecting to the data. You have a couple of
choices; check the Word 2002 section of my website's Mail Merge FAQ. Look at
"Numeric and Date formatting" under the part on Connections.

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

Reply to this Message

PCOR - 12 Feb 2004 03:26 GMT

Thnaks for the help...sure did the trick for me

> Hi Pcor,
>
[quoted text clipped - 18 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)

Reply to this Message