I have VBA code in Access that sends email with attachments to about 500 veterans. My ISP has a limit of 100 email being sent at one time. My code creates all the email and then uses MyMail.Send which puts all the email into the Outbox. I want to have all the email go to say the Draft folder where I can then take groups of 100 and move them to the Outbox for sending.
The second line of code below is the issue. Is there a way to not say .send but .save to the Draft Folder?
'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
The second line of code below is the issue. Is there a way to not say .send but .save to the Draft Folder?
'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