Combine email

[Leesha]

Hi,

I have a table that has a column that contains email addresses. I would like to be able to run a query where the end result has all of the addresses in one cell. Each address would be separated by a comma. I plan to copy and past the results into an email. Is it possible to do this and if so how would it look?
Thanks,
Leesha

[JohnH]

Have a look at this thread.
You need to use the Concat function.

[HansV]

The post mentioned by John is for use in Excel. An Access version can be found in this post.

[JohnH]

OOps....Sorry.

I made the mistake of thinking that the Search Box at the top of this page was a "Search within this forum" search.

I see that there is a different Search box for that.