I am trying to send an email with multiple attachments using CDONTS.
The code below sends the email, but never attaches anything.
I feel like I've got a vb script errror where I scroll through the record set rsEQUIPInvoicesAttach, which contains 2 records.
If I take that loop out of my code, I can manually create an email with multiple attachments, so I'm confident my CDO syntax is correct.
<% if (cStr(Request("Submit")) <> "") Then
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.From = Request("varFrom")
objCDO.To = Request("varTo")
objCDO.Subject = "Invoices from Schmidt Equipment"
objCDO.Body = "Invoices from Schmidt Equipment"
While ((Repeat6__numRows <> 0) AND (NOT rsEQUIPInvoicesAttach.EOF))
Set objCDO = Nothing
Repeat6__numRows = -1
Repeat6__index = 0