I have a query, qryFindEMails with a field containing e-mail addresses. I want to combine these e-mails into a string:
email1-at-wherever.com; email2-at-wherever.com; email3-at-wherever.com
... and then append this string to a textbox on a form. (I have removed all the @ symbols hereas they kept turning my example string into a series of hyperlinks)
I have tried doing it by populating a multi-select listbox using the query but can't get it to work and, in any case, I want every item in the list so why have to select them all? I have trawled through the boards at length, searching with various combinations of words, and can't find anything which has allowed me to solve the problem. I have found stuff which looks as if it might help but my VBA just isn't good enough, sadly
Any help very gratefully received
Thanks
email1-at-wherever.com; email2-at-wherever.com; email3-at-wherever.com
... and then append this string to a textbox on a form. (I have removed all the @ symbols hereas they kept turning my example string into a series of hyperlinks)
I have tried doing it by populating a multi-select listbox using the query but can't get it to work and, in any case, I want every item in the list so why have to select them all? I have trawled through the boards at length, searching with various combinations of words, and can't find anything which has allowed me to solve the problem. I have found stuff which looks as if it might help but my VBA just isn't good enough, sadly
Any help very gratefully received
Thanks
Last edited: