Tony,

Maybe try a code on the same site but this URL:
http://www.rondebruin.nl/cdo.htm
There is a code that connects to gmail smtp server and sends emails
from the account you connect to on the fly.
You can adjust your code - introduce some counter variable and
whenever the counter reaches 500 - make the code switch the account
it's connecting to.

That should do the trick.
A.

On Jul 14, 7:26*pm, Webtechie
wrote:
Ryan,

Good to know mail code tips. *But it did not say anything about changing the
from address when sending out to cells in a certain range.

The one range code was how to select a range and send mail (1 address). *I
will need to take a range and make it come from one "From Address", take the
next range and make it come from the next "From Address" (acct. #2).

Thanks

Tony



"ryguy7272" wrote:
I think this will do what you want:
http://www.rondebruin.nl/mail/folder2/files.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

"Webtechie" wrote:

Hello,

I need to create a macro to email the contacts for our company. *Currently,
we have a gmail account which has been configured in Outlook.

Now gmail has a limit of 500 emails a day. *My boss was to send out 1500. *I
have searched the web and see google's response is create multiple accounts.

Question:

How would I program a macro to use multiple email accounts? *I've created
macros to email items before. *But not sure how to write an email macro to
use multiple accounts. *

I know I will create 10 more gmail accounts. *I know to configure all of
them in Outlook. *But how to program the macro so that it does a "Round
Robin"? *Send the first 500 contacts with this account, the next 500 contacts
with account 2 and so on.

Thanks for pointing me in the right direction.

Tony- Hide quoted text -

- Show quoted text -