R
Robert T
I am testing two different Email Merges based upon queries of the current
record from Access 2003. It's our student registration database and we want
to advise students they are registered for training classes. Some times we
will notify everyone in one class and at other times, we will notifiy one
student refrerence all of their training classes. Each form has a different
parent table, however, both of them are using the same child table called
tblLink [Many to Many design].
The first email merge is based on a query of the current record on a One to
Many form which uses One Class to Many Students. The email sends a
confirmation to every student who is registered in this particular class.
However, I’m having a problem with the 2nd merge and that’s where I need help.
The 2nd Email Merge uses a One to Many form where there is One Student to
Many Classes. Obviously in this scenario I want to send only one email to the
student advising they are registered for the following classes. The merge
works, however, it sends a SEPARATE email for each class. For example, if one
student is registered for 6 training classes, they will receive 6 email
confirmations, one for each class. That works with the first scenario
described above, but it’s a problem here. There must be a way to fetch
through all of the child records in the query and send only ONE email to the
student showing all of their classes.
Any thoughts?
Thanks,
Robert
record from Access 2003. It's our student registration database and we want
to advise students they are registered for training classes. Some times we
will notify everyone in one class and at other times, we will notifiy one
student refrerence all of their training classes. Each form has a different
parent table, however, both of them are using the same child table called
tblLink [Many to Many design].
The first email merge is based on a query of the current record on a One to
Many form which uses One Class to Many Students. The email sends a
confirmation to every student who is registered in this particular class.
However, I’m having a problem with the 2nd merge and that’s where I need help.
The 2nd Email Merge uses a One to Many form where there is One Student to
Many Classes. Obviously in this scenario I want to send only one email to the
student advising they are registered for the following classes. The merge
works, however, it sends a SEPARATE email for each class. For example, if one
student is registered for 6 training classes, they will receive 6 email
confirmations, one for each class. That works with the first scenario
described above, but it’s a problem here. There must be a way to fetch
through all of the child records in the query and send only ONE email to the
student showing all of their classes.
Any thoughts?
Thanks,
Robert