Hi Folks
I am trying to produce a report based on a query that will display all the e-mails of clients selected from a query. In the table the query is working from, each client has their own record and their e-mail is just one of the fields for their record. The catch here is that I want to display these e-mails in a format that can be copy and pasted right into "Send To" part of an email as a group in microsoft exchange or outlook. The format is pretty straight forward, just put ";" between each email, but what expression do I use to create this uninterupted list of emails?
I want it to come out like this: kull@canoemail.com;bill@nkx.ca;sam@uvic.ca;etc.
Keep in mind, I am looking at producing a list that could contain thousands of email addresses. Thanks in advance to any help.
I am trying to produce a report based on a query that will display all the e-mails of clients selected from a query. In the table the query is working from, each client has their own record and their e-mail is just one of the fields for their record. The catch here is that I want to display these e-mails in a format that can be copy and pasted right into "Send To" part of an email as a group in microsoft exchange or outlook. The format is pretty straight forward, just put ";" between each email, but what expression do I use to create this uninterupted list of emails?
I want it to come out like this: kull@canoemail.com;bill@nkx.ca;sam@uvic.ca;etc.
Keep in mind, I am looking at producing a list that could contain thousands of email addresses. Thanks in advance to any help.
