I have a table with names, email addresses, statuses etc. of all my users, some of them are active some are inactive. What I want is to create a button that for a selection of users e.g. those with staus=active will create a draft email in my outlook and paste all the email addresses from the table. I have already added ';' at the end of each address so it would separate one from another. It does work if i choose just one address with ='maito:' [field name]
I assume I have to create a sting of values from the possible email adresses to then put it into [field name] place.
i need this solution, because i'm tring to update in a dinamic way the result of a match function, without changing the script (but only a variable in an input box and adding a line in an excel document)
I wanted to explain this becase if you have another way of thinking should be great!