Results 1 to 9 of 9

Thread: VB code to email Crystal report

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Aug 2006
    Posts
    107

    VB code to email Crystal report

    Hi,
    Anyone could help me for VBcode to send Crystal report by email? I have the code to print out the crystal report, but now i need the report can be email directly.

    Below is my Print out sample:-

    Public Sub ShowSalesInv(ByVal blnPreview As Boolean, ByVal sInvRefNo As String)
    Dim SalesInvReport As Report
    Dim Db As Database
    Dim strTitle As String

    Set SalesInvReport = New ICRSalesInv
    Set Db = SalesInvReport.Database
    SalesInvReport.RecordSelectionFormula = " {tbl_Sales.InvRefNo}='" & sInvRefNo & " '"

    If blnPreview = True Then
    Set frmCrystalViewer.mRptReport = SalesInvReport
    frmCrystalViewer.Caption = strTitle & "Invoice"
    frmCrystalViewer.Show 1
    Else
    SalesInvReport.PrintOut True does any code could replace here for email?
    End If

    End Sub

    Would appreciate for any help. Thanks.

    -Ana-
    Last edited by anatasia; Mar 29th, 2007 at 03:51 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width