Proc to return email addresses from ID's
Posted on 2013-11-01
I have a checkboxlist bound with id's and names, what I need to do is send an email to everyone selected.
I'm checking for the checked boxes and creating a comma separated list of ID's. I need to convert these ID's into email Addresses from SQL.
In my web app I have a function:
Dim SendToEmails As String = Communication.GetEmailByID("SendToIDs")
This calls a helper function that returns a string of emails, its this I'm having trouble with. I want to convert the stings of ID's into a string of emails that cam be used in the recipient field of the mail object.
Or does anyone have a better way. I can't use the email address as the ID field as not all users will have an email address. (I have to sort this bit out later - I need to know which users didn't get sent am email)