I have a form with a SendTo field which can contain multiple names, with additional names added at any time. I want to be able to send an e-mail to any name in that list who hasn’t been sent the e-mail already. Any ideas on how to do that? Do I need to set up a table?
Subject: Sending mail only to people who haven’t received yet
J63,
How are you sending the mail? Automatically or programmatically?
If programmatically, when the email goes, just update a second field (recipients) to show who you have already sent it to. When you send the email, loop through each SendTo member and check they are no a member of the recipients field
HTH
Mike
Subject: RE: Sending mail only to people who haven’t received yet
Thanks! That’s a great idea. One other related question. I’m also setting up an agent to send a reminder to people 14 days after the first e-mail was sent. How would I track the date the first e-mail was sent to each person?
Subject: RE: Sending mail only to people who haven’t received yet
You could have 2 multi-value fields side-by-side. One with the Recipients and one with the SentDate
Teh agent could loop through the SentDate field and everytime it finds the correct date (ie Today - 14 ), it looks at the corresponding item in the Recipeint field
You will need to know the position of the date in the field to get the corresponding name (look at @Member/@Element etc etc for @formula, or do a ForAll loop using script, with a counter)
HTH
Mike