[Mrs Dumm]

All,
I can do this the hard way (multiple merges and then copy and paste into one
doc) but I'd love to be able to do IF statements that filter by Job Title and
merge all jobs of the same ilk in each section. I'm dealing with RN's, PCT's
and UC's. And I'm making a phone list where all the RN's are in one section
by alpha, all the PCT's are in another section by alpha and the UC's are in
another section.

I can do an IF statement for any one of the above ({If {MERGEFIELD
JobType}="RN", [field, field, field], {NextRecord}}) which should merge the
record only if the JobType is "RN" and go to the NextRecord if it is not.
The doc is set up as a table (I tried the directory merge and couldn't get
the darn thing to do more than one on a page, dang it!) with the fields and
then "next record".

The question is, how would I restart the merge so that it starts over in the
next section and filters for "PCT" in the JobType field? Is this possible
without VBA?

Your assistance, as always, is appreciated. Everyone at work always asks me
how I know so much about Word and Excel and I always tell them it is merely
by the kindness of others who know WAY more than I that I have learned
anything at all!

Thanks,
Alicia

[Graham Mayor]

You cannot restart a merge halfway through. It proceeds from start to end.
What you are trying to achieve is complicated, but not impossible to
achieve - see How to use mail merge to create a list sorted by category in
Word 2002 - http://support.microsoft.com/?kbid=294686 (although the page
title says 2002, it works with other Word versions).

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Mrs Dumm wrote:
All,
I can do this the hard way (multiple merges and then copy and paste
into one doc) but I'd love to be able to do IF statements that filter
by Job Title and merge all jobs of the same ilk in each section. I'm
dealing with RN's, PCT's and UC's. And I'm making a phone list where
all the RN's are in one section by alpha, all the PCT's are in
another section by alpha and the UC's are in another section.

I can do an IF statement for any one of the above ({If {MERGEFIELD
JobType}="RN", [field, field, field], {NextRecord}}) which should
merge the record only if the JobType is "RN" and go to the NextRecord
if it is not. The doc is set up as a table (I tried the directory
merge and couldn't get the darn thing to do more than one on a page,
dang it!) with the fields and then "next record".

The question is, how would I restart the merge so that it starts over
in the next section and filters for "PCT" in the JobType field? Is
this possible without VBA?

Your assistance, as always, is appreciated. Everyone at work always
asks me how I know so much about Word and Excel and I always tell
them it is merely by the kindness of others who know WAY more than I
that I have learned anything at all!

Thanks,
Alicia

[macropod[_2_]]

Hi Graham,

I've posted a tutorial on this, with working field codes and a sample Excel data source, at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

--
Cheers
macropod
[MVP - Microsoft Word]


"Graham Mayor" wrote in message ...
You cannot restart a merge halfway through. It proceeds from start to end.
What you are trying to achieve is complicated, but not impossible to
achieve - see How to use mail merge to create a list sorted by category in
Word 2002 - http://support.microsoft.com/?kbid=294686 (although the page
title says 2002, it works with other Word versions).

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Mrs Dumm wrote:
All,
I can do this the hard way (multiple merges and then copy and paste
into one doc) but I'd love to be able to do IF statements that filter
by Job Title and merge all jobs of the same ilk in each section. I'm
dealing with RN's, PCT's and UC's. And I'm making a phone list where
all the RN's are in one section by alpha, all the PCT's are in
another section by alpha and the UC's are in another section.

I can do an IF statement for any one of the above ({If {MERGEFIELD
JobType}="RN", [field, field, field], {NextRecord}}) which should
merge the record only if the JobType is "RN" and go to the NextRecord
if it is not. The doc is set up as a table (I tried the directory
merge and couldn't get the darn thing to do more than one on a page,
dang it!) with the fields and then "next record".

The question is, how would I restart the merge so that it starts over
in the next section and filters for "PCT" in the JobType field? Is
this possible without VBA?

Your assistance, as always, is appreciated. Everyone at work always
asks me how I know so much about Word and Excel and I always tell
them it is merely by the kindness of others who know WAY more than I
that I have learned anything at all!

Thanks,
Alicia

[Graham Mayor]

I'll change my autotext to include the link

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



macropod wrote:
Hi Graham,

http://support.microsoft.com/?kbid=294686


"Graham Mayor" wrote in message
...
You cannot restart a merge halfway through. It proceeds from start
to end. What you are trying to achieve is complicated, but not
impossible to achieve - see How to use mail merge to create a list
sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686 (although the page title
says 2002, it works with other Word versions). --

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Mrs Dumm wrote:
All,
I can do this the hard way (multiple merges and then copy and paste
into one doc) but I'd love to be able to do IF statements that
filter by Job Title and merge all jobs of the same ilk in each
section. I'm dealing with RN's, PCT's and UC's. And I'm making a
phone list where all the RN's are in one section by alpha, all the
PCT's are in another section by alpha and the UC's are in another
section. I can do an IF statement for any one of the above ({If
{MERGEFIELD
JobType}="RN", [field, field, field], {NextRecord}}) which should
merge the record only if the JobType is "RN" and go to the
NextRecord if it is not. The doc is set up as a table (I tried the
directory merge and couldn't get the darn thing to do more than one
on a page, dang it!) with the fields and then "next record".

The question is, how would I restart the merge so that it starts
over in the next section and filters for "PCT" in the JobType
field? Is this possible without VBA?

Your assistance, as always, is appreciated. Everyone at work always
asks me how I know so much about Word and Excel and I always tell
them it is merely by the kindness of others who know WAY more than I
that I have learned anything at all!

Thanks,
Alicia

[Mrs Dumm]

Thank you both! I will investigate both:

http://support.microsoft.com/?kbid=294686

and

http://www.wopr.com/cgi-bin/w3t/show...?Number=731107

I'll post back if I have any problems and/or any editorial comments I might
have :-)

This newsgroup is a godsend and I have BOTH of your websites in my
favorites! Thanks for answering. Alicia
"Graham Mayor" wrote:

I'll change my autotext to include the link

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



macropod wrote:
Hi Graham,

http://support.microsoft.com/?kbid=294686


"Graham Mayor" wrote in message
...
You cannot restart a merge halfway through. It proceeds from start
to end. What you are trying to achieve is complicated, but not
impossible to achieve - see How to use mail merge to create a list
sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686 (although the page title
says 2002, it works with other Word versions). --

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Mrs Dumm wrote:
All,
I can do this the hard way (multiple merges and then copy and paste
into one doc) but I'd love to be able to do IF statements that
filter by Job Title and merge all jobs of the same ilk in each
section. I'm dealing with RN's, PCT's and UC's. And I'm making a
phone list where all the RN's are in one section by alpha, all the
PCT's are in another section by alpha and the UC's are in another
section. I can do an IF statement for any one of the above ({If
{MERGEFIELD
JobType}="RN", [field, field, field], {NextRecord}}) which should
merge the record only if the JobType is "RN" and go to the
NextRecord if it is not. The doc is set up as a table (I tried the
directory merge and couldn't get the darn thing to do more than one
on a page, dang it!) with the fields and then "next record".

The question is, how would I restart the merge so that it starts
over in the next section and filters for "PCT" in the JobType
field? Is this possible without VBA?

Your assistance, as always, is appreciated. Everyone at work always
asks me how I know so much about Word and Excel and I always tell
them it is merely by the kindness of others who know WAY more than I
that I have learned anything at all!

Thanks,
Alicia