I'm writing a database for a volunteer organisation (Being one off the volunteers) I'm almost done, its been three solid days and my brain is fried.
I want to add a custom function to send an email to the trustees and the those labelled as Staff with an attachment containing registered responders (Search and Rescue Response)
I can get it to send to either Member Type = "WSCCT Trustee" or Member Type = "WSCCT Staff" but I can't work out the syntax to to create a list "Recieve" containig both WSCCT Trustee and WSCCT Staff, I've tried numerous things including creading two lists but it always says it is wrong.
Script is below. Sorry if this is mundane basic stuff I just need to get it done tonight and have been googling for hours.
void email.WSCCT_Responder_List()
{
for each Recieve in WSCCT_Contacts[Member_Type == "WSCCT Trustee"]
{
sendmail
[
from :zoho.adminuserid
to :Recieve.Email
subject :"WanderSearch Canterbury - Responder List"
message :"Please find attached a spreadsheet for the Current WSCCT Responders"
Attachments :view:WSCCT_Responders as pdf
]
}