May 5 2010, 01:30 PM
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:
firstname.lastname@example.org; email@example.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.
May 5 2010, 08:54 PM
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.
May 6 2010, 08:14 AM
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.