Mail merge from 2 data sources

L

Liene

I need to merge mail from 2 data sources. One table with email address and
number to recipient. Second with one to many names witch are related to the
one recipient in table one.
Is it possible and how do I do it.
I have these 2 tables in one access database and is related by number.

Liene
 
D

dlw

make a query in access that combines the two tables, export it to a
spreadsheet, do the mailmerge in word
 
L

Liene

Yes I did that.
Now is my data are somesing like this (simplified):

Number;BusinessName;email address;Name1;Address1;
1;"Supper";[email protected];Linda;her address1;
1;"Supper";[email protected];Hans;his address;
2;"Lego";[email protected];Kristine;Markvej 3;
2;"Lego";[email protected];Martin;Markvej 7;

If I take these 4 lines as example. Then I need to send 2 mails.
One to [email protected] and another to [email protected]
But into those letters I need to write like this:

Letter 1:
Dear Linda and Hans

Letter 2:
Dear Kristine and Martin

How do I do that?

"dlw" skrev:
 
Top