Merge introduces 0 instead of house number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dominic - 22 Feb 2006 15:25 GMT

I've got a large mailing list in Excel which I filter in order to print
labels. I create new excel documents then use them to print labels in Word.
With a small number of entries, when I try to print the labels, some of the
addresses suffer from the house number being replaced by a zero (0). There
seems to be no pattern. I've tried refomatting the list in Excel as plain
text, cutting and pasting the text only into a new document, re-typing new
entries. The house number and street name are in different columns in Excel.
When I filter by some criteria, when I merge into Word, I could have four
addresses on the same street and a few labels end up printing "0 Some Street".
For example:
12 Some St
34 Some St
Rose Cottage, 42 Some St
Apple House, 50 Some St

could print as:
12 Some St
0 Some St
Rose Cottage, 42 Some St
0 Some St

I can see no pattern, nor can I work out what's causing it. Any ideas?
Thanks.

Reply to this Message

Doug Robbins - Word MVP - 22 Feb 2006 18:42 GMT

Try changing the method of connection to the data source to DDE. To do
that, from the Tools menu in Word, select Options and then go to the General
tab and check the box against the "Confirm conversions at open" item. Then
when you attach the data source, you will be given and option for the method
by which the connection is made.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> I've got a large mailing list in Excel which I filter in order to print
> labels. I create new excel documents then use them to print labels in
[quoted text clipped - 24 lines]
> I can see no pattern, nor can I work out what's causing it. Any ideas?
> Thanks.

Reply to this Message