How can I copy a list of email addresses from my excel spreadsheet and send one email. The email I use is from Go Daddy and is web-based email. When I try to copy and paste, it will copy the whole list but only paste the first email address.

First question: Are you spamming people?

Not at all. This is for my business. I have email address from my clients but when I need to send an announcement or reminder, I would like to be able to do multiple instead of one at a time.

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: http://help.godaddy.com/article/2793 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: Sub BuildAddy() 'Build single string of addy's separated by a semi-colon and space For Each addy In Range("A1:A10") tmpAddy = tmpAddy & addy & "; " Next 'Strip off last semi-colon and space bigAddy = Left(tmpAddy, Len(tmpAddy) - 2) 'Put string in B1 Range("B1") = bigAddy End Sub This should create a string in B1 like: me@there.com; you@here.com; etc@otherplaces.com You should be able to copy/paste into the To: field in your email.