getting emails from excel

Microsoft Excel 2000/visual basic for ap...
August 5, 2009 at 08:08:32
Specs: Windows XP
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.

See More: getting emails from excel

Report •

August 5, 2009 at 09:20:48
First question: Are you spamming people?

Report •

August 5, 2009 at 10:34:17
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.

Report •

August 5, 2009 at 11:43:15
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:

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 & "; "
'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:;;

You should be able to copy/paste into the To: field in your email.

Report •

Related Solutions

Ask Question