Hi guys

I'm quite new to mail merge, and have been having some trouble for days now.
I've found numerous examples on the Internet, and have had some success, but
cannot complete the solution.

I have a small (fixed number of 12 records) and simple Excel database. Each
row is a new record. Let's just say each record has a person's name and
their favourite colour.

What I want to do is, in Word, say:

"The following people's favourite colour is blue: John and Tim."
"The following people's favourite colour is green: Tony and Bill."
etc etc

I want to achieve this by cycling through the database, finding the people's
records that contain "blue", and write down their forename. Sounds pretty
simple, but the problem is that there are several people who have different
favourite colours, and the records are in no order.

Firstly, I tried something like this:


The following people's favourite colour is blue: { IF {MERGEFIELD Colour } =
"Blue" { MERGEFIELD "Name" } "" }{ NEXT }

etc etc



This works absolutely fine, and inserts the correct names. However, when I
come to the next colour, green, it doesn't work (I assume because I have
come to the end of the database?).



I then thought I'd try setting bookmarks then referring to them later once
they've been stored. For argument's sake, let's say there will always be 2
people that like the same colour; no more and no less.



So I did something like this:



{ SET blue { IF { MERGEFIELD Colour } = "Blue" { MERGEFIELD "Name" }
"" } }{ NEXT }{ SET blue { IF { MERGEFIELD Colour } = "Blue" { MERGEFIELD
"Name" } "" } }



The problem here is that the bookmark gets overwritten by the second name
and also it doesn't solve the problem of storing names for each colour!

I'm in a real helpless position and don't know what else to try! Any help
would be much appreciated. Many thanks in advance.

I don't think you can do exactly what you want but you may be able to come
close to it using a directory or catelog type merge. I would recommend
looking at Cindy Meister's web sight for ideas.
http://homepage.swissonline.ch/cindy...r/MergFram.htm

Here are a few links to some other mailmerge resources:
http://word.mvps.org/FAQs/index.htm
http://addbalance.com/usersguide/mailmerge.htm
http://addbalance.com/word/wordwebresources.htm#Fields

--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"John Tesler" wrote in message
...
Hi guys

I'm quite new to mail merge, and have been having some trouble for days
now. I've found numerous examples on the Internet, and have had some
success, but cannot complete the solution.

I have a small (fixed number of 12 records) and simple Excel database.
Each row is a new record. Let's just say each record has a person's name
and their favourite colour.

What I want to do is, in Word, say:

"The following people's favourite colour is blue: John and Tim."
"The following people's favourite colour is green: Tony and Bill."
etc etc

I want to achieve this by cycling through the database, finding the
people's records that contain "blue", and write down their forename.
Sounds pretty simple, but the problem is that there are several people who
have different favourite colours, and the records are in no order.

Firstly, I tried something like this:


The following people's favourite colour is blue: { IF {MERGEFIELD Colour }
= "Blue" { MERGEFIELD "Name" } "" }{ NEXT }

etc etc



This works absolutely fine, and inserts the correct names. However, when I
come to the next colour, green, it doesn't work (I assume because I have
come to the end of the database?).



I then thought I'd try setting bookmarks then referring to them later once
they've been stored. For argument's sake, let's say there will always be 2
people that like the same colour; no more and no less.



So I did something like this:



{ SET blue { IF { MERGEFIELD Colour } = "Blue" { MERGEFIELD "Name" }
"" } }{ NEXT }{ SET blue { IF { MERGEFIELD Colour } = "Blue" { MERGEFIELD
"Name" } "" } }



The problem here is that the bookmark gets overwritten by the second name
and also it doesn't solve the problem of storing names for each colour!

I'm in a real helpless position and don't know what else to try! Any help
would be much appreciated. Many thanks in advance.

You are trying 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/cindy...faq1.htm#DBPic


Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

--
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

"John Tesler" wrote in message
...
Hi guys

I'm quite new to mail merge, and have been having some trouble for days
now. I've found numerous examples on the Internet, and have had some
success, but cannot complete the solution.

I have a small (fixed number of 12 records) and simple Excel database.
Each row is a new record. Let's just say each record has a person's name
and their favourite colour.

What I want to do is, in Word, say:

"The following people's favourite colour is blue: John and Tim."
"The following people's favourite colour is green: Tony and Bill."
etc etc

I want to achieve this by cycling through the database, finding the
people's records that contain "blue", and write down their forename.
Sounds pretty simple, but the problem is that there are several people who
have different favourite colours, and the records are in no order.

Firstly, I tried something like this:


The following people's favourite colour is blue: { IF {MERGEFIELD Colour }
= "Blue" { MERGEFIELD "Name" } "" }{ NEXT }

etc etc



This works absolutely fine, and inserts the correct names. However, when I
come to the next colour, green, it doesn't work (I assume because I have
come to the end of the database?).



I then thought I'd try setting bookmarks then referring to them later once
they've been stored. For argument's sake, let's say there will always be 2
people that like the same colour; no more and no less.



So I did something like this:



{ SET blue { IF { MERGEFIELD Colour } = "Blue" { MERGEFIELD "Name" }
"" } }{ NEXT }{ SET blue { IF { MERGEFIELD Colour } = "Blue" { MERGEFIELD
"Name" } "" } }



The problem here is that the bookmark gets overwritten by the second name
and also it doesn't solve the problem of storing names for each colour!

I'm in a real helpless position and don't know what else to try! Any help
would be much appreciated. Many thanks in advance.

Thanks for the replies everyone. I'll check out the provided links and give
it a go, and post back. :-)