prmitchell
Registered User.
- Local time
- Today, 17:53
- Joined
- Jan 2, 2013
- Messages
- 58
Hello
I have a table - tblBarSessions - with similar data to the following which is just an example
I know how to program a loop to process the recordset
and I know how to use the DoCmd.SendObject to send all of the records in a recordset to an email address
but when reaching record three in the sample above - given it is a different email address from the previous - how do I exactly at that point send an email to the first email address with just the first two (in this case) records
and then to keep proceeding until again a different email address is encountered
advice / pseudocode / code / links - any or all will be most appreciated
Thanks in anticipation
I have a table - tblBarSessions - with similar data to the following which is just an example
Subject | ShiftDate | StartTime | eA |
Shed Lunch I: Bill | 1/03/2023 | 11:00 AM | bgates@iinet.com.au |
Bowls: Bill | 8/03/2023 | 3:45 PM | bgates@iinet.com.au |
Shed Lunch: Satya | 1/03/2023 | 11:00 AM | snadella@hotmail.com |
Bowls: Satya | 15/03/2023 | 3:45 PM | snadella@hotmail.com |
Bowls: Satya | 22/03/2023 | 3:45 PM | snadella@hotmail.com |
I know how to program a loop to process the recordset
and I know how to use the DoCmd.SendObject to send all of the records in a recordset to an email address
but when reaching record three in the sample above - given it is a different email address from the previous - how do I exactly at that point send an email to the first email address with just the first two (in this case) records
and then to keep proceeding until again a different email address is encountered
advice / pseudocode / code / links - any or all will be most appreciated
Thanks in anticipation
Last edited: