Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / April 2008

Tip: Looking for answers? Try searching our database.

Merging only some names from a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
FormerWAF - 09 Apr 2008 20:31 GMT
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 - 10 Apr 2008 05:17 GMT
Where do you have the list?  It would be better to do the data manipulation
in the source rather than via mail merge

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 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,
[quoted text clipped - 4 lines]
>
> Will appreciate any help as I am very frustrated.
FormerWAF - 10 Apr 2008 14:59 GMT
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.

> Where do you have the list?  It would be better to do the data manipulation
> in the source rather than via mail merge
[quoted text clipped - 7 lines]
> >
> > Will appreciate any help as I am very frustrated.
Doug Robbins - Word MVP - 10 Apr 2008 20:52 GMT
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.

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

> The list is in Excel and when I downloaded it from the web site, it
> changed
[quoted text clipped - 17 lines]
>> >
>> > Will appreciate any help as I am very frustrated.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.