Hope everyone is doing good.
this is my first post in the forum and i find it great. i have a database that i use to send mass emails to agents that have cases on thier queue basiclly i run just a macro and macro run a function than emails start sending through outlook that should be open, everything works fine and never have a problem, now what i would like to do is to send mass email in HTML format using ASP, below is the code i use in access.
On Error GoTo ErrorHandler
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim Outlook As Outlook.Application
Dim Email As Outlook.MailItem
Dim sSubject As String
Dim sBody As String
Dim fso As FileSystemObject
Dim Body As TextStream
Dim BodyText As String
Set Outlook = New Outlook.Application
'set up the database and query connections
Set db = CurrentDb()
'clear working table
'add data to working table
Set rs = db.OpenRecordset("tSendEmails", dbOpenDynaset)
'loop through our list of addresses,
'adding them to e-mails and sending them.
Do Until rs.EOF
'create the e-mail
Set Email = Outlook.CreateItem(olMailItem)
'address the e-mail
Email.To = rs("Email")
'subject of the e-mail
Email.Subject = "Case on Your Queue"