Combine records with a common field into one single record


G

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
 
Ad

Advertisements

L

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

Kurt P said:
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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top