Multiple email recipients

(2 posts) (2 voices)


No tags yet.

  1. xerxes42, Member


    I'm setting up multiple reports that the user can choose to get the report sent to them by email and a number of user needs to be able to sent the reports to multiple users.
    I can use multiple 'dbr.mail.recipient' to add recipient but it requires that it's defined number of recipients.
    Is there a way to allow the user to enter a comma separated list of several email addresses in a varchar or text field and them have them added as recipients?
    Or do I need to parse the field and find all email addresses, put them in a temporary table or use a prepared statement to be able to sent to multiple recipients.


  2. myDBR Team, Key Master

    you can use the dbr.mail.recipient-command to include any number of recipients:

    select 'dbr.mail.recipient', email, name
    from mymailrecipients;

    myDBR Team


You must log in to post.