But did you try going through selecting the data source again? I wasn't sure
from your message. Just restarting Word (or Windows) probably won't make any
difference.

The values in the two suspect columns are not-numeric, but DDE
shouldn't care, right?

Right.

Peter Jamieson

grover wrote in message ...
Thanks again Peter

No, the two columns I have added in the Excel sheet don't appear as
part of the selection criteria. I've shut down and restarted all to no
avail. The values in the two suspect columns are not-numeric, but DDE
shouldn't care, right?

On Sun, 23 Apr 2006 18:25:04 +0100, "Peter Jamieson"
wrote:

Did it appear in the list of columns available for insertion? If not, you
probably need to go through the connection process again to see the new
column in the spreadsheet. If it did, not sure what is happening...

Peter Jamieson

grover wrote in message
. ..
Many thanks for the reply! I can now produce lables, but I have one
more question if I may...

I added a column to the spreadsheet, "bad Address", but it doesn't
show up as part of the selection criteria. All the other columns are
there....... Environment is all Office 2003.

Thanks again.


On Sun, 23 Apr 2006 16:17:04 +0100, "Peter Jamieson"
wrote:

I loaded Word 2003

Your best bet, particularly if you were using Word 2000 or earlier is to
check Word Tools|Options|General|"Confirm conversion at open" and
reconnect,
selecting the DDE option when offered (you will only see the last sheet
you
had open). It's also useful to enable the Mailmerge toolbar, e.g. in
Tools|Customize|Toolbars, because it doesn't appear/disappear
automatically
like the old one in Word 2000/97 etc.

The dialog box with the "equal to, or blank, or non blank, etc." options
is
the query options dialog which you can get to using the 3rd button down
in
the /old/ Mail Merge Helper. In Word 2003 you can use the "Mailmerge
recipients" button on the Mailmerge toolbar, then either select the
records
in there, or click the top of one of the columns and choose the
"Advanced..." option to get the dialog. Or, you can go into
Tools|Customize|Commands, select category All Commands, locate the
MailMergeQueryOptions command in the right hand column and drag it to a
toolbar (such as the mailmerge toolbar)

Peter Jamieson





b. i

grover wrote in message
m...
After a crash, I loaded Word 2003.

I do a yearly mailing, with the data contained in an Excel workbook. I
used to be able to set up the lable, pint to the data source
spreadsheet, and get a form where I could select, for different
fields, equal to, or blank, or non blank, etc.

Now, when I "get data" from the spreadsheed, it asks me to select a
"table", and gives me choices - such as alpha$, etc. - none of which
connect to my desired data......

What am I doing wrong? I've even added the old Helper to my tool bar
with the same results..

thanks for help