Mail Merge Email

  • Thread starter Thread starter Haas
  • Start date Start date
H

Haas

I want to send a mail merged email to around 350 indivituals but I have the
following problem.
each student has more certificate nos with expire date, i.e.
STudent No. Certificate No. Expiry Date email
1 123 12/12/2002 student 1 email
1 142 12/12/2002 student 1 email
2 230 15/12/2007 student2 email
2 111 13/05/2006 student 2 email

When i do the email merge it gives each row as a one record whereas i need
each student to apear once and below it his/her respective certificates i.e.:
Student 1
123 12/12/2002
42 12/12/2002
and outlook to send one single email to each student listing their
respective certifices.
anyhelp
 
You'd need to use a relational database to do something like that since
you'd need to have each additional cert in the same record with the first to
only send 1 email.









** Please include your Outlook version, Account type, and Windows Version
when requesting assistance **
 
No, your data source needs to be redundant for Word/Outlook mail merges.

To make your data redundant you should have 2 tables in your database for
this;
-one called Students with Student No. as the primary key and students
name/email as a field.
-one called Certificates with Certificate No. as the primary key and Expiry
Date as field and the Student No. as a foreign key.

Then create a select query in Access to join the tables (via the Student
No) and then use the query as the data source.
 
Thank you very much men, very helpful, but I tried as below, the result is
same like the excel list I have.

How can i make the query to give me one student No. and his email against
all his certificates.

Thank you again your effort, i appreciate men your assitance.
Regards
Haas
 
Back
Top