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 / March 2004

Tip: Looking for answers? Try searching our database.

Mail merge selects wrong data

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Simonb - 07 Mar 2004 11:37 GMT
Hope this query makes sense - my first post..

I'm using Word2003 mail merge to add address block into
standard letters. Data source is Excel 2003 XLS, & I'm
using "advanced" filter facility within mail merge.

At step 3 of 6, I browse to correct tab within XLS and
all data is displayed correctly. I then select "advanced"
filtering in column headings, because I want selection:
col A = "N" AND col B = blank AND col C = not blank.

Data is filtered correctly, so I press OK and carry on
with mail merge. At step 5 I find that too many records
have been selected because the filter table has been
corrupted - for example it now says col B = blank AND col
B = not blank, so it selects nearly all records!

Any suggestions? My only workaround suggestion is to use
Excel to do the filtering, then copy the filtered data to
another tab and merge without using the WORD2003 filters.

Any other ideas? I'll be very grateful for any
suggestions.
Graham Mayor - 08 Mar 2004 06:53 GMT
Most mail merge issues are covered in
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm.
It is usually best to manipulate data in the data source than in Word where
possible.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
    Graham Mayor -  Word MVP

     Web site www.gmayor.com
 Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

> Hope this query makes sense - my first post..
>
[quoted text clipped - 19 lines]
> Any other ideas? I'll be very grateful for any
> suggestions.
simonb - 08 Mar 2004 14:53 GMT
Graham - many thanks for the link - it's good to know
that I am not alone in struggling with this problem!
what a useful site this is - never realised it was here.
>-----Original Message-----
>Most mail merge issues are covered in
[quoted text clipped - 27 lines]
>
>.
 
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.