View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Merging to A, B,C...

Some clarification please: can we assume that you know how to select
either the As (may be possible in the Query options facility, or you
might be able to add a SKIPIF field to your mail merge main document
that does something like

{ SKIPIF { MERGEFIELD "Last Name" } = "A*" }

then change the A to B, B to C to do each batch) or the record numbers?
If so, is it the automation part you want, i.e. you want to be able to
merge batch A (or 1-100), then, as a separate step, batch B, without
having to change the selection criteria?

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Michael Koerner wrote:
I have no problem setting up my merge from Excel to Word onto an Envelope
for all the names I have in the spread sheet. What I would like to be able
to do is merge where it uses the first letter of the Last Name and be able
to merge where all records begin with A, then again for B and so on.

Or even the ability to select say 50 records, then records 51-100, then
101-150 and so on. Any help greatly appreciated. I'm using XP and Office
2007