As much as 2500 email address are listed in column A in one of my xl
file, they are all my clients, to which I need to send email. Can
send 2500 emails in a row with excel2003 and my outlook2003

--
hanasam
-----------------------------------------------------------------------
hanasamo's Profile: http://www.excelforum.com/member.php...fo&userid=2534
View this thread: http://www.excelforum.com/showthread.php?threadid=39409

Hello,

Except for spam, it is possible to email the workbook from XL.
If you want to send a simple email without attachment, look for mailmerge in
help.
Outlook is blocking xl if you make a connection to outlook to send email.
This will
not be the case if your code reside within Outlook.
Another way is to use the FollowHyperlink method that will create the email
but will NOT send it.
You have to use Sendkeys to trigger the sending.
That way, you are blocking your PC during all time your code is running and
is sending emails.

HTH
Regards,

Jean-Yves

"hanasamo" wrote in
message ...

As much as 2500 email address are listed in column A in one of my xls
file, they are all my clients, to which I need to send email. Can I
send 2500 emails in a row with excel2003 and my outlook2003?


--
hanasamo
------------------------------------------------------------------------
hanasamo's Profile:
http://www.excelforum.com/member.php...o&userid=25344
View this thread: http://www.excelforum.com/showthread...hreadid=394099