Create Distribution List from Table

[pkelly]

Hi...

I have a table (EmployeeMaster) which has the following field "emp_EmailAddress".

As the name suggests, this is an employee table.

I want to create a variable called "emailTo" which will be populated which each of the email addresses in the table seperated by a ";".

For example...

If the table contained joe.bloggs@here.com and jim.bloggs@there.com, I would end up with a variable that looks like...

joe.bloggs@here.com; jimk.bloggs@there.com;

I will be using this to populate the to field in an e-mail....

Thanks in adavance for any help on this...

Paul

[#2 · Accepted solution]

Hi,

Use Concat function for SQL:

SQL select concat(emp_EmailAddress, '; ') from EmployeeMaster

[pat_agen]

hi,

alternatively if you have already loaded your EmployeeMaster into a qvw then the following varaible will get you your list:

let vListEmails='=concat(emailTo,' & chr(039) & ';' & chr(039) & ')';