Why did you move it from Excel? That is a better database for your email
addresses. Also, while I can tell you how to easily add a semicolon at the
end of each email address in Excel, you don't need to do this.
Instead
of trying to send an email to mass recipients on a single email, you should
send each person an individual email. This will help make sure your email
reaches the intended recipients. Many email programs will treat emails with
a massive list of email addresses in the message header as spam. (Not to
mention those who harvest email address for sending spam LOVE to get their
hands on these types of emails!) I'm also wondering if you really do have
10,000 email addresses and plan to use them all in the same message header
if you'd even be able to send it to all of them at once.
A better method is to use Mail Merge which will send the same email to each
individual - the result is 10,000 emails that you didn't have to manually
prepare yourself. It sounds like you already have your data source created
in Excel so the hard part is done. Just specify your main document is for
E-Mail Messages and use your Excel workbook as the data source. If you need
help on walking through the process then here's an article that contains
step-by-step instructions.
http://office.microsoft.com/en-us/help/HA010349201033.aspx
Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook
Word FAQ:
http://mvps.org/word
TechTrax eZine:
http://mousetrax.com/techtrax/
MVP FAQ site:
http://mvps.org/