Combine records with a common field into one single record

[Guest]

I have a list of names, to whom I want to send mail. Each record is a seperate person. Each record also contains a field which is "MAILID", a unique code for each household. So, for example, if Mary and John Smith have the same address, then they have the same household id code (MAILID). The problem is, I want to create a file such that I could combine both Mary and John Smith into one record so that I could then mail to "Mary and John Smith" or something like that so that both names would show up on the mailing list. (First name and Last name are seperate fields).

Is there a simple way to do this? I really don't know how to do VB code, so I am hoping someone has a good solution.

thanks

 

[Luiz Cláudio]

Hi,

I don't think it's possible unless you use some VB code to loop through the
records and create strings such as "Jonh and Mary".

[]
Luiz Cláudio C. V. Rocha
São Paulo - Brazil
MVP Office

I have a list of names, to whom I want to send mail. Each record is a

seperate person. Each record also contains a field which is "MAILID", a
unique code for each household. So, for example, if Mary and John Smith
have the same address, then they have the same household id code (MAILID).
The problem is, I want to create a file such that I could combine both Mary
and John Smith into one record so that I could then mail to "Mary and John
Smith" or something like that so that both names would show up on the
mailing list. (First name and Last name are seperate fields).

Is there a simple way to do this? I really don't know how to do VB code,

so I am hoping someone has a good solution.

 

[Guest]

Actually, was able finally to solve in Excel using a formula found at www.cpearson.com/excel/duplicat.htm. Thanks