I am using crystal reports XI R2 and having problems emailing a report from Access (VBA). The code I am using is as follows:
Me.crxReport.ExportOptions.FormatType = crEFTPortableDocFormat
Me.crxReport.ExportOptions.DestinationType = crEDTEMailMAPI
Me.crxReport.ExportOptions.MailSubject = "A Subject"
Me.crxReport.ExportOptions.MailMessage = "Message"
Me.crxReport.ExportOptions.MailToList = strEmailAddress
Me.crxReport.Export False <---- ERROR MESSAGE
ERROR MESSAGE
Run-time error '-2147190908 (80047784)' Failed to export the report
I have created other functions that export PDFs to a file and this works fine, it is just with sending emails I am having problems. Any suggestions?