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?
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?
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" <hanasamo.1th8af_1123556725.3589@excelforum-nospam.com> wrote in
message news:hanasamo.1th8af_1123556725.3589@excelforum-nospam.com...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks