|Thanks for the answer. |
2 options come to mind:
1 - Use the instructions at GoDaddy for creating distribution lists from CSV files which can easily be created from Excel files:
2 - Create a single text string within Excel and paste that into the To: field in your emails. (I tested this in Outlook)
For example, with your list of email addresses in A1:A10, (and hopefully nothing in B1) run this code:
'Build single string of addy's separated by a semi-colon and space
For Each addy In Range("A1:A10")
tmpAddy = tmpAddy & addy & "; "
'Strip off last semi-colon and space
bigAddy = Left(tmpAddy, Len(tmpAddy) - 2)
'Put string in B1
Range("B1") = bigAddy
This should create a string in B1 like:
email@example.com; firstname.lastname@example.org; email@example.com
You should be able to copy/paste into the To: field in your email.