Mail merge from 2 data sources

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
make a query in access that combines the two tables, export it to a
spreadsheet, do the mailmerge in word
 
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 (e-mail address removed) and another to (e-mail address removed)
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:
 
Back
Top