The join works, and I can get UE to send out one email message at the scheduled time.
But only one message, which is the problem. This is an iteration issue -- it's a loop-within-a-loop problem, where I don't think UE is set to loop at all. I keep breaking the code when I try to force the loop myself.
My rsMessages recordset has TWO messages in it, so I need a way to iterate the recordset. I'm also worried about the message recipients, because it looks like UE only runs one query to get the recipients, and I need it to run multiple queries; one for each message, since each message has a different recipient list. The loops would probably look something like this:
Get message recordset
For each record in rsMessages
---Get recipient recordset (since it's different for every record)
------free recipient results
The only thing in the forum I could find that came close was this thread
and only the last post about adding a fetch statement seemed really on-target, but when I tried that fix everything broke.
My broken code is attached. I'm not sure it's any help, as it's (um) broken.