I have code that send email and attachments to about 500 people. My ISP has a limit of 100 email at one time.
Currently when I run the job all the email goes immediately to the Outbox. What I want to do is have the email go to a folder where I can then copy a batch of 100 emails to the Outbox for distribution and repeat this until the 500 are sent.
Therefore in the second line where it reads MyMail.Send (goes immediately to Outbox)
I want MyMail.some other folder name here.
HTML Code:
'This sends it!
MyMail.Send
'Some people have asked how to see the e-mail instead of automaticially sending it.
'Uncomment the next line And comment the "MyMail.Send" line above this.
'MyMail.Display
'And on to the next one...
MailList.MoveNext
Loop
'Cleanup after ourselves
Set MyMail = Nothing
'Uncomment the next line if you want Outlook to shut down when its done. Otherwise, it will stay running.
'MyOutlook.Quit
Set MyOutlook = Nothing
MailList.Close
Set MailList = Nothing
db.Close
Set db = Nothing