EMAIL List of recipients

Ok, having a dumb moment,

I have a list of cells, a1 through a10 each containing an email address.

i need to combineall email addresses into a string, so i can then run my macro:

EG:

.To = "JohnDoe@anywhere.com; JaneDoe@anyplace.com"

Thanks John, Solved before i read your reply.

With the help of: www.rondebruin.nl

Example attached

And of course, the code:

Please Login or Register  to view this content.