Monthly Billing Statement Update Event Email Error: Sp_OASetProperty Send Returns -2147220980
sp_OASetProperty Send returns -2147220980; Source: CDO.Message.1 Description: At least one recipient is required, but none were found
Root Cause:
This message will be generated when there is no email address for a borrower set to receive electronic statements because electronic statements require an email address. When there is no email address for the borrower, an email with this message is instead sent to your company email address, which is the Originating E-Mail Address field set in the System Administration Company table.
Workaround:
- Update the Customer Service Borrower screen for the borrower to have a correct email address.
To find the borrower or borrowers with no email address who have electronic statements enabled, have your local IT or system administrator run the SQL command script below to select the information from your Fusion Servicing Director database. Note: The email sent to the originating email address shows the last 4 digits of a loan number, but the loan digits shown are for a loan not related to the issue. You can't use the loan digits in the email to find the borrower with no email address. - Execute the following from a SQL Server Management Studio New Query screen to get a list of the borrowers:
USE Service
GO
SELECT BEA.LoanID
,BEA.BorrowerID
,BEA.AssmRecCounter
,BEA.EmailAddress
FROM MOBillStmtHistory_Hdr AS Hdr ( NOLOCK )
JOIN Company AS C ( NOLOCK )
ON Hdr.CompanyKey = C.CompanyKey
AND Hdr.StatementDate = C.PriorTransPostDate
JOIN Loan AS L ( NOLOCK )
ON Hdr.LoanID = L.LoanID
AND L.StatementPresentationType IN ( 1, 2 )
JOIN BorrowerEmailAddress AS BEA ( NOLOCK )
ON L.LoanID = BEA.LoanID
AND BEA.EmailAddressVerified = 1
WHERE BEA.EmailAddress is
GO
ArticleNumber:
000041730