Re: Excel - Word Mail Merge

From: Suzanne S. Barnhill (sbarnhill_at_mvps.org)
Date: 10/16/04 

Date: Sat, 16 Oct 2004 09:03:47 -0500

Yes, the query options would allow you to filter the data. If you added a
field for member/nonmember, you could certainly filter on that. In Word 2002
and above, if the list is not huge, you can use the Mail Merge Recipients
dialog to select exactly those records you want included in the merge (or
select them all and deselect some). 

-- 
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"Maureen Smith" <mobetta56@nospamhotmail.com> wrote in message
news:efZwPzzsEHA.2596@TK2MSFTNGP15.phx.gbl...
> There is, I guess - it's not contained in the data at all; it was more
along
> the lines of "these people in this area are members of this organization;
> these people are not; I want the mailing to go to the people who are not."
>
> The filters of which you speak - is the the query option that comes up
when
> one is doing the merge?
>
> Suzanne S. Barnhill <sbarnhill@mvps.org> wrote in message
> news:uRr$WTssEHA.1408@TK2MSFTNGP10.phx.gbl...
> > Assuming there is some principle on which the addresses are being
omitted,
> > it would be better to use filters in Word rather than hide the rows in
> > Excel.
> >
> > --
> > Suzanne S. Barnhill
> > Microsoft MVP (Word)
> > Words into Type
> > Fairhope, Alabama USA
> > Word MVP FAQ site: http://word.mvps.org
> > Email cannot be acknowledged; please post all follow-ups to the
newsgroup
> so
> > all may benefit.
> >
> > "Maureen Smith" <mobetta56@nospamhotmail.com> wrote in message
> > news:%23Dh1EKmsEHA.160@TK2MSFTNGP11.phx.gbl...
> > > I'm working with an Excel file, a statewide address list. I've been
> asked
> > to
> > > generate mailing labels, but of course not to everyone on the list.
The
> > > "list maker" has hidden the rows of addresses he does not want the
> mailing
> > > to go to.  When I do a mail merge in Word, I get blank labels for what
> I'm
> > > assuming are
> > > the hidden rows. The addresses are not all in adjacent rows.
> > >
> > > Is this doable without a lot of dancing around? I'm using Word and
Excel
> > > 2000.
> > >
> > > Thanks.
> > >
> > >
> > >
> > >
> >
>
>

Relevant Pages

  • Re: Merging only a few companies from the total database in WORD
    ... I think you are talking about Query options - that is where the trouble ... text or number you want to compare with the contents of the data field. ... On the Filter Records tab, I clicked Company, Casler ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Merging only a few companies from the total database in WORD
    ... Then in the Filter dialog of Query Options, ... Unsolicited questions forwarded ... >> Doug Robbins - Word MVP ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Bug in Mailmerge Filters?
    ... which suggests that the only way to avoid the problem is to avoid using ODSO, which /probably/ means that you have to use the connection methods that predate ODSO, e.g. DDE for Excel and Access. ... Is the query only parsed when the Query options dialog box is displayed) that it would be difficult to draw any further conclusions without a much closer look, and perhaps knowledge of Word's source code, but that does correspond roughly with what I remember about this. ... filter, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail merger helper not inserting correct data into word docume
    ... I am trying to put information into an existing mail merge word document. ... bring up the mail merge helper and using query options I then set the field - ... is it a filter on a date ... > Do you use the same data source and filter all the time? ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mailmerge Querystring Problems
    ... Query options to set a filter... ... > accept any WHERE clause on the mailmerge querystring property. ... > Dim strSQL As String ...
    (microsoft.public.word.mailmerge.fields)