I have a database on a server at my clients location. I have developed a BUTTON to send reports by Email. The following is the code:
Private Sub EmailEqRpt_Click()
Dim strWhere As String
strWhere = "[Property Number] = "& Me.[Property Number]
DoCmd.OpenReport "RESERVE REQUIREMENT REPORT ADMIN", acPreview, ,strWhere
DoCmd.SendObject acSendReport, "RESERVE REQUIREMENT REPORT ADMIN",acFormatPDF
DoCmd.Close acReport, "RESERVE REQUIREMENT REPORT ADMIN", acSaveNo
End Sub
(this has been pasted from Word, and may not have the correct spacing.)
This has been working fine using Windows Live Mail on the clients server, however, after June 30th I keep getting a Run Time '2293' Microsoft Access cannot send this Email.
I have made the recommended adjustments to Windows Live Mail, given by Microsoft and the Windows Live Mail works fine on the server if I open Windows Live mail and just create an email. However, when within Access clicking on the "Email Report" button I get the aforementioned error.
Any suggestions?