Multiple email recipients

(2 posts) (2 voices)

Tags:

No tags yet.

  1. xerxes42, Member

    Hi,

    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.

    Brgds

  2. myDBR Team, Key Master

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

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

    --
    myDBR Team


Reply

You must log in to post.