View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
nospaminlich nospaminlich is offline
external usenet poster
 
Posts: 3
Default Mail Merge Address Data Problem

I have an Excel 2003 "database" of names, addresses etc. where one of the
fields is House Number.

When I use this data to create address labels in Word 2003 via Mail Merge
everything is OK apart from those cells where the House Number also contains
a letter e.g. 39A which appears on the label as 0.

How do I overcome this? Ideally I don't want to change the data layout in
Excel as I've had to keep it simple for user entry.

Thanks a lot in anticipation

Kewa