In my organisation, we have some contact list in an access database which are about 200 records. i have a command button in access that inserts all the contacts into my outlooks new message (mailto. The problem is that our organisation email server does not send mails to up to 200 contacts at a time except the number is halved to say 100 contacts. it recognises it as sending spam

i need to develop some kind of vba code that will divide all the 200 contacts into 2 and send both sets of 100 contacts the same message.

what are my different options apart from doing it manually which defeats the purpose of IT?

actually, some messages bounce back from the recipeints email sever because they are too many, so webmails and organisation mail servers dont allow messages with so many contacts to go through cos they see it as spam mails.

Actually how can i write a code to send individual messages to multiple Recipients without using any kind of addins

Instead of using lots of lists, why don't you create a queue and loop through it, sending each one uniquely?

So how exactly can i do this?

I haven't done that before with VBA [only with VB.NET]. Can you show me the e-mail code you have currently.

I haven't got any code, i am just thinking of the logic before I dream of coding.