Email Invoice

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • DD
    #1

    Email Invoice

    Hi
    I want to email Invoice ID1 from a list of Invoices in a datasheet

    My code for printing is
    strDocName = "rptInvoice "
    strWhere = "[InvID]=" & Me.fsubPrintInv oice.Form![InvID]
    DoCmd.OpenRepor t strDocName, acPreview, , strWhere

    I am trying the following adjustment with the sendObject

    'DoCmd.SendObje ct acSendReport, "rptInvoice " = "[InvID]=" &
    Me.fsubPrintInv oice.Form![InvID], acFormatSNP, _
    "", , , "Your Invoice....", "If you can not view the report
    you will need to download the free SnapShot reader at
    www.microsoft.com/downloads (Search by Keywords SnapShot)", True

    And it is not working
    Can anyone help or advise a better method

    Regards
    DD
    Tags: None
    • Filips Benoit
      #2
      Re: Email Invoice

      "rptInvoice " = "[InvID]=" & Me.fsubPrintInv oice.Form![InvID],
      See correction below
      "rptInvoice ", "InvID]=" & Me.fsubPrintInv oice.Form![InvID],

      Filip

      "DD" <david.deacon@b igpond.com.au> wrote in message
      news:1412655e.0 408022218.6ac3f dde@posting.goo gle.com...[color=blue]
      > Hi
      > I want to email Invoice ID1 from a list of Invoices in a datasheet
      >
      > My code for printing is
      > strDocName = "rptInvoice "
      > strWhere = "[InvID]=" & Me.fsubPrintInv oice.Form![InvID]
      > DoCmd.OpenRepor t strDocName, acPreview, , strWhere
      >
      > I am trying the following adjustment with the sendObject
      >
      > 'DoCmd.SendObje ct acSendReport, "rptInvoice " = "[InvID]=" &
      > Me.fsubPrintInv oice.Form![InvID], acFormatSNP, _
      > "", , , "Your Invoice....", "If you can not view the report
      > you will need to download the free SnapShot reader at
      > www.microsoft.com/downloads (Search by Keywords SnapShot)", True
      >
      > And it is not working
      > Can anyone help or advise a better method
      >
      > Regards
      > DD[/color]


        Comment

        Previous template Next
        Working...