I am trying to send emails to people in a list in excel. I created a loop to get the different email addresses and send the email to each addressee using gmail. it works fine if the list has 7 or fewer addressees, after seven i get an error that the transport failed to connect to the server.

That's good it can do 7 or fewer addresses which proved the code is close to working.

Now you need to talk to your email provider about how they throttle email sending. Remember this is NOT BROKEN but by design to halt spammers.

Also, you neglected to reveal all the details so no one can do more than guess.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.