[FormerWAF]

I have a list of 8,000 members. I want to merge based on 3 columns, names
(Non-blank), Bad Address (Blanks) and Paid Thru (date). When I do this, it
still gives me all 8,000 labels. I can sort the date column but I can't make
it print just those equal to or less than (date).

Will appreciate any help as I am very frustrated.

[Doug Robbins - Word MVP]

Where do you have the list? It would be better to do the data manipulation
in the source rather than via mail merge

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

"FormerWAF" wrote in message
...
I have a list of 8,000 members. I want to merge based on 3 columns, names
(Non-blank), Bad Address (Blanks) and Paid Thru (date). When I do this,
it
still gives me all 8,000 labels. I can sort the date column but I can't
make
it print just those equal to or less than (date).

Will appreciate any help as I am very frustrated.

[FormerWAF]

The list is in Excel and when I downloaded it from the web site, it changed
all the dates to xxxxx and I don't know how to change it back to numbers. If
I can, then I could sort it from there. Thanks for trying.

"Doug Robbins - Word MVP" wrote:

Where do you have the list? It would be better to do the data manipulation
in the source rather than via mail merge

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

"FormerWAF" wrote in message
...
I have a list of 8,000 members. I want to merge based on 3 columns, names
(Non-blank), Bad Address (Blanks) and Paid Thru (date). When I do this,
it
still gives me all 8,000 labels. I can sort the date column but I can't
make
it print just those equal to or less than (date).

Will appreciate any help as I am very frustrated.

[Doug Robbins - Word MVP]

Are the dates displayed as "xxxxx" in Excel because the column width is too
narrow to display them properly or are they really replaced by "xxxxx" If
the latter, then there is no way that you could sort the data on that field
in Excel, let alone in Word.

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

"FormerWAF" wrote in message
...
The list is in Excel and when I downloaded it from the web site, it
changed
all the dates to xxxxx and I don't know how to change it back to numbers.
If
I can, then I could sort it from there. Thanks for trying.

"Doug Robbins - Word MVP" wrote:

Where do you have the list? It would be better to do the data
manipulation
in the source rather than via mail merge

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

"FormerWAF" wrote in message
...
I have a list of 8,000 members. I want to merge based on 3 columns,
names
(Non-blank), Bad Address (Blanks) and Paid Thru (date). When I do
this,
it
still gives me all 8,000 labels. I can sort the date column but I
can't
make
it print just those equal to or less than (date).

Will appreciate any help as I am very frustrated.