I need to prepare several large distribution lists from lists of email addresses. Each address is in it's own cell in an Excel 2010 worksheet. Also, I added a semi-colon to the end of each address because that's what needs to separate the addresses. I need to get this list into a distribution group (aka Contact List) in Outlook. The list of names can be copied into the group list if I could get them into a string like "firstname.lastname@example.org;name2@hot
.com; etc. etc.".
Does anyone know how I can get this column of data into a string like this?
A sample file with a list of names is attached to play with.