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

  1. Open your Crystal Reports document and go to File > Export > Email.
  2. In the Email dialog box, select the email client you want to use (e.g., Outlook, Gmail, etc.).
  3. Configure the email settings as needed (e.g., subject, body, recipient, etc.).
  4. 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:

  1. Crystal Reports Email Add-in: This add-in allows you to send reports as email attachments directly from Crystal Reports.
  2. Report Burst: This add-in provides a simple way to burst reports and send them as email attachments.
  3. 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:

  1. Create a new Visual Basic project and add a reference to the Crystal Reports runtime library.
  2. Use the Crystal Reports API to open the report and export it to a PDF file.
  3. Use the email client's API (e.g., Outlook Object Library) to create a new email message and attach the PDF file.
  4. 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!