If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Email Merge Based upon a One to Many Form Query
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 |
Thread Tools | |
Display Modes | |
|
|