"0" appears in Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JT - 28 Feb 2006 16:13 GMT

I am doing what I think is a simple merge of data from an Excel sheet into
mailing labels in Word. However my "address" column in Excel (which contains
address data) merges into the Word labels with only a "0" where the address
should be.

I can't seem to get the address data over. Any help is very much appreciated.

JT

Reply to this Message

Cindy M -WordMVP- - 28 Feb 2006 17:35 GMT

Hi =?Utf-8?B?SlQ=?=,

> I am doing what I think is a simple merge of data from an Excel sheet into
> mailing labels in Word. However my "address" column in Excel (which contains
> address data) merges into the Word labels with only a "0" where the address
> should be.

It always helps to tell us which version of Word (or Office) is involved?

In this case, please also copy the contents of a couple of these cells into your
reply so we can see what kind of data it contains.

Best guess: the majority of the first eight or so records have numeric content,
only, in this column. So Excel is marking it as numeric and passing a 0 for all
records that contain text.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
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

Rate this thread: