I have a query that captures the e-mail address field of a table and lists them as individual records.

I need to be able to grab each of these records and put them into a 'copy-from' field so they can be pasted into the "To" line of Outlook in this format:

abc@gmail.com; red@aol.com: blue @nobody.com

I am currently having to copy/paste these into Excel and do it but this is pretty clunky.

Any help would be appriciated.

You'll need to do this in a VBA function.

There have been a number of examples of this posted here. A search on the term "concatenation" should turn up some good ones.

I did the search and read seveal of the posts but my head is spinning! There's so much information there yet I can't seem to see a post that reflects the same requirements.

Here is a discussion that speaks to your exact requirement