Burst crystal reports by e mail
A classic problem!
Bursting a Crystal Reports document by email can be a bit tricky, but it's doable. Here are a few approaches:
Method 1: Using Crystal Reports' built-in feature
- Open your Crystal Reports document and go to File > Export > Email.
- In the Email dialog box, select the email client you want to use (e.g., Outlook, Gmail, etc.).
- Configure the email settings as needed (e.g., subject, body, recipient, etc.).
- Click OK to send the report as an email attachment.
Method 2: Using a third-party add-in
There are several third-party add-ins available that can help you burst Crystal Reports documents by email. Some popular options include:
- Crystal Reports Email Add-in: This add-in allows you to send reports as email attachments directly from Crystal Reports.
- Report Burst: This add-in provides a simple way to burst reports and send them as email attachments.
- Crystal Reports Emailer: This add-in allows you to send reports as email attachments and also provides features like report scheduling and notification.
Method 3: Using a programming language
If you're comfortable with programming, you can use a programming language like Visual Basic, C#, or Java to automate the process of bursting and sending Crystal Reports documents by email. Here's a high-level example of how you might do this using Visual Basic:
- Create a new Visual Basic project and add a reference to the Crystal Reports runtime library.
- Use the Crystal Reports API to open the report and export it to a PDF file.
- Use the email client's API (e.g., Outlook Object Library) to create a new email message and attach the PDF file.
- Send the email using the email client's API.
Here's some sample Visual Basic code to get you started:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Imports Outlook = Microsoft.Office.Interop.Outlook
Sub BurstAndSendReport()
' Create a new instance of the Crystal Reports engine
Dim report As New ReportDocument
' Load the report
report.Load("C:\Path\To\Report.rpt")
' Export the report to a PDF file
Dim pdfFile As New File
pdfFile.FileName = "Report.pdf"
pdfFile.SaveOptions = SaveOptions.OpenType
report.ExportToPdf(pdfFile)
' Create a new email message
Dim outlookApp As New Outlook.Application
Dim mailItem As Outlook.MailItem
mailItem = outlookApp.CreateItem(0)
' Set the email properties
mailItem.Subject = "Report Burst"
mailItem.Body = "This is a report burst email."
mailItem.To = "[email protected]"
' Attach the PDF file to the email
Dim attachment As Outlook.Attachment
attachment = mailItem.Attachments.Add(pdfFile.FileName)
attachment.PropertyAccessor.SetProperty("http://schemas.microsoft.com/mapi/proptag/0x3712001F", "Report.pdf")
' Send the email
mailItem.Send()
End Sub
I hope these methods help you burst your Crystal Reports documents by email!