I have this e-mail module written that i found by searching around here.. but i am trying to add a second .To recipient however it is not passing it off to the e-mail client. I have tried adding .CC and .BCC to the code as well and neither work. Am i missing something simple?
Code:
Sub RTFBodyX()
Const ForReading = 1, ForWriting = 2, ForAppending = 3
Dim fs, f
Dim RTFBody, strTo
Dim MyItem As Outlook.MailItem
Dim MyApp As New Outlook.Application
DoCmd.OutputTo acOutputQuery, "dncsend", acFormatHTML, "dncsend.htm"
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.OpenTextFile("dncsend.htm", ForReading)
RTFBody = f.ReadAll
'Debug.Print RTFBody
f.Close
Set MyItem = MyApp.CreateItem(olMailItem)
With MyItem
.To = "void@nams-inc.com; paulk@courtesycall.com"
.Subject = "Voids & DNC's"
.HTMLBody = RTFBody
End With
MyItem.Display
End Sub