Microsoft Office Tutorials and References
In Depth Information
Sending a Message Individually to Multiple Recipients
Out
Figure 71 – Sending E-mail Messages to Multiple Recipients
View the Appendix to learn how to store this procedure
in a Standard (Excel) module.
Option Explicit¶
' * * * * *¶
'Outlook Application Objects declaration¶
Dim objItem As Object 'Outlook.MailItem¶
'Applicaton Ontime variable declaration¶
Dim myRunTime As Double¶
'Send & Receive interval in second - set to desired interval¶
Const myInterval = 5 * 60¶
'How many emails to send in a single Send & Receive¶
'Set as needed¶
Const howMany = 20¶
'Excel Worksheet Object¶
Search JabSto ::




Custom Search