No Fix To My Merge Problem???

[Suzanne]

I've been told (by Doug R) that what I'm trying to do (see my first message
at the bottom) is impossible. So, before giving up, I'm shooting this out to
the Word Programming Community for ideas.

This should be possible. For example -- can't I tell Word that if -- in my
case -- Room#1 is entered into a field, to then "send" the rest of the
information down to the second page; or split the merge commands; or...
(?????)

I have already tried a "continuous break" on the two page form (so that it
appears to be one continuous page) with a hard page break at the Room# field
(with no luck so far).

Again, I can't believe this is not possible... if I can (easily) setup a
one-page
test form which does have all individuals listed in their respective rooms,
there has to be some way to do it on a two-page form.

Thanks -- Suz


:

Sounds like you are wanting to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

[ This site provided no useful information ]

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

[ I've been referring to this article for two days hoping I missed
something useful ]

or at:

http://cornell.veplan.net/article.aspx?&a=3815 [ not much more use than
above ]

--
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 two page form.

The room number {MERGEFIELD "ROOM" } is on the first page

I want to put the names of all people assigned to the room on the second
page.

I need a new form started for each room.

I've tried variations of the following, obviously with no success:

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }" "" }{ SET Place1 {
MERGEFIELD
CITY }} { If { Place2 } <> { Place1 }" { MERGEFIELD CITY }¶

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Where, in my case, "CITY" is "ROOM; "EMPLOYEE" is "LAST"; "SALES" is
"FIRST"

Help... please...

Suzanne

 

[Tony Strazzeri]

Hi Suz,

Doug knows what he is talking about. The print merge is very limited
in what it can do.

The only suggestion I can make is for you to write a macro to perform
a similar function to the print merge but add the additional tests and
respponse to the macro.

by this I mean that you would need to read in the data file one record
at a time and populate the output fully under macro control.

Hope this makes sense.

Cheers
TonyS.

I've been told (by Doug R) that what I'm trying to do (see my first message
at the bottom) is impossible. So, before giving up, I'm shooting this out to
the Word Programming Community for ideas.

This should be possible. For example -- can't I tell Word that if -- in my
case -- Room#1 is entered into a field, to then "send" the rest of the
information down to the second page; or split the merge commands; or...
(?????)

I have already tried a "continuous break" on the two page form (so that it
appears to be one continuous page) with a hard page break at the Room# field
(with no luck so far).

Again, I can't believe this is not possible... if I can (easily) setup a
one-page
test form which does have all individuals listed in their respective rooms,
there has to be some way to do it on a two-page form.

Thanks -- Suz

:

Sounds like you are wanting to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

[ This site provided no useful information ]

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

[ I've been referring to this article for two days hoping I missed
something useful ]

or at:

http://cornell.veplan.net/article.aspx?&a=3815[ not much more use than
above ]

--
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 two page form.

The room number {MERGEFIELD "ROOM" } is on the first page

I want to put the names of all people assigned to the room on the second
page.

I need a new form started for each room.

I've tried variations of the following, obviously with no success:

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }" "" }{ SET Place1 {
MERGEFIELD
CITY }} { If { Place2 } <> { Place1 }" { MERGEFIELD CITY }¶

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Where, in my case, "CITY" is "ROOM; "EMPLOYEE" is "LAST"; "SALES" is
"FIRST"

Help... please...

Suzanne

 

[Suzanne]

If anyone happens to read this post in the future looking for a fix to
multi-page merge with multiple conditions...

Peter Jamieson was absolutely AWESOME with support for this issue.

This was totally resolved. Look for my posts on the mail merge thread
(search for 'Suzanne' and select the one with 14 or so posts).

The number one fix that I wish I had come up with earlier was adding another
field to my Excel worksheet which joined data from two columns, thus leaving
me with two instead of three conditional fields (I'll heartily agree that
Word cannot produce required outputs on three separate conditions). Again, a
very simple fix.

I'll leave the form Peter worked on for me (thanks again Peter!!) on my
Office Live website (http://suzleigh.com/MERGE.aspx) for a little while (or
e-mail me (e-mail address removed) for a GREAT example of a two page merge (in
a table format) from multiple conditions (there's also a mock Excel workbook
that goes with it on my site).

Suzanne

Hi Suz,

Doug knows what he is talking about. The print merge is very limited
in what it can do.

The only suggestion I can make is for you to write a macro to perform
a similar function to the print merge but add the additional tests and
respponse to the macro.

by this I mean that you would need to read in the data file one record
at a time and populate the output fully under macro control.

Hope this makes sense.

Cheers
TonyS.

I've been told (by Doug R) that what I'm trying to do (see my first message
at the bottom) is impossible. So, before giving up, I'm shooting this out to
the Word Programming Community for ideas.

This should be possible. For example -- can't I tell Word that if -- in my
case -- Room#1 is entered into a field, to then "send" the rest of the
information down to the second page; or split the merge commands; or...
(?????)

I have already tried a "continuous break" on the two page form (so that it
appears to be one continuous page) with a hard page break at the Room# field
(with no luck so far).

Again, I can't believe this is not possible... if I can (easily) setup a
one-page
test form which does have all individuals listed in their respective rooms,
there has to be some way to do it on a two-page form.

Thanks -- Suz

:

Sounds like you are wanting to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

[ This site provided no useful information ]

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

[ I've been referring to this article for two days hoping I missed
something useful ]

or at:

http://cornell.veplan.net/article.aspx?&a=3815[ not much more use than
above ]

--
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 two page form.

The room number {MERGEFIELD "ROOM" } is on the first page

I want to put the names of all people assigned to the room on the second
page.

I need a new form started for each room.

I've tried variations of the following, obviously with no success:

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }" "" }{ SET Place1 {
MERGEFIELD
CITY }} { If { Place2 } <> { Place1 }" { MERGEFIELD CITY }¶

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Where, in my case, "CITY" is "ROOM; "EMPLOYEE" is "LAST"; "SALES" is
"FIRST"

Help... please...

Suzanne

 

[Russ]

For everybody's convenience, here's a link to that aforementioned message
thread from the mailmerge group:

<http://groups.google.com/group/microsoft.public.word.mailmerge.fields/brows
e_thread/thread/326a090cc452ec7d/0b810f5311832f45?hl=en&lnk=gst&q=%22help+wi
th+embedded%22+ingroup%3Amailmerge&rnum=1#0b810f5311832f45>

If anyone happens to read this post in the future looking for a fix to
multi-page merge with multiple conditions...

Peter Jamieson was absolutely AWESOME with support for this issue.

This was totally resolved. Look for my posts on the mail merge thread
(search for 'Suzanne' and select the one with 14 or so posts).

The number one fix that I wish I had come up with earlier was adding another
field to my Excel worksheet which joined data from two columns, thus leaving
me with two instead of three conditional fields (I'll heartily agree that
Word cannot produce required outputs on three separate conditions). Again, a
very simple fix.

I'll leave the form Peter worked on for me (thanks again Peter!!) on my
Office Live website (http://suzleigh.com/MERGE.aspx) for a little while (or
e-mail me (e-mail address removed) for a GREAT example of a two page merge (in
a table format) from multiple conditions (there's also a mock Excel workbook
that goes with it on my site).

Suzanne

Hi Suz,

Doug knows what he is talking about. The print merge is very limited
in what it can do.

The only suggestion I can make is for you to write a macro to perform
a similar function to the print merge but add the additional tests and
respponse to the macro.

by this I mean that you would need to read in the data file one record
at a time and populate the output fully under macro control.

Hope this makes sense.

Cheers
TonyS.

I've been told (by Doug R) that what I'm trying to do (see my first message
at the bottom) is impossible. So, before giving up, I'm shooting this out
to
the Word Programming Community for ideas.

This should be possible. For example -- can't I tell Word that if -- in my
case -- Room#1 is entered into a field, to then "send" the rest of the
information down to the second page; or split the merge commands; or...
(?????)

I have already tried a "continuous break" on the two page form (so that it
appears to be one continuous page) with a hard page break at the Room# field
(with no luck so far).

Again, I can't believe this is not possible... if I can (easily) setup a
one-page
test form which does have all individuals listed in their respective rooms,
there has to be some way to do it on a two-page form.

Thanks -- Suz

:

Sounds like you are wanting to perform a "multiple items per condition (=key
field)" mailmerge which Word does not really have the ability to do:

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at

http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic

[ This site provided no useful information ]

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default.aspx?scid=kb;en-us;211303

[ I've been referring to this article for two days hoping I missed
something useful ]

or at:

http://cornell.veplan.net/article.aspx?&a=3815[ not much more use than
above ]

--
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 two page form.

The room number {MERGEFIELD "ROOM" } is on the first page

I want to put the names of all people assigned to the room on the second
page.

I need a new form started for each room.

I've tried variations of the following, obviously with no success:

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }" "" }{ SET Place1 {
MERGEFIELD
CITY }} { If { Place2 } <> { Place1 }" { MERGEFIELD CITY }¶

{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Where, in my case, "CITY" is "ROOM; "EMPLOYEE" is "LAST"; "SALES" is
"FIRST"

Help... please...

Suzanne