Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004

    Unanswered: Email Report from Preview Screen

    Can anyone offer any ideas on how I might enable a user to email a report directly from the Preview screen? The user wants to preview the report and then rather that closing it, clicking the Email option and reentering the criteria, she wants to simply email from the preview.


  2. #2
    Join Date
    Sep 2003
    In the preview screen. do right click on the report, select 'Send To....Mail Recipient(as Attachment).

  3. #3
    Join Date
    Dec 2003
    Dallas, TX
    Hi JenChan101

    Once you get that all figured out, here is something that I created for a user that Emailed reports routinely within the company. It was done from a form that let's them decide which report to send. They would then click on the CommandButton which in turn would automatically send this report. The user already knew what the reports were, though the data contained changed everyday. It was a daily report of the Checks written out each day.

    Hope this helps some as well and have a nice one,
    BTW, This was done in a FUNCTION that I created.

    Option Compare Database
    ' modSendMainRpt_Bud
    Function modSendMainRpt_Bud()
    On Error GoTo modSendMainRpt_Bud_Err
        ' Sends a copy of the report to selected individuals.
        DoCmd.SendObject acReport, "rptChecksReleasedDateSelect", 
    "SnapshotFormat(*.snp)", "BUD", "", "",
     "Report for Checks Released Today", 
    "Here are the checks that were released for today.", True, ""
        Exit Function
        MsgBox Error$
        Resume modSendMainRpt_Bud_Exit
    End Function

Posting Permissions

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