send current report as attachment

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • barkarlo
    New Member
    • Nov 2006
    • 59

    send current report as attachment

    I made a report who has many pages.
    Now,I would like send current page in a report (like attachment) to Microsoft office outlook, but i do'nt know.
    I tried , but always send all pages from a report.
    thanks for you answer!
  • sierra7
    Recognized Expert Contributor
    • Sep 2007
    • 446

    #2
    Hi

    What version of Access are you using?? I hear in 2007 you can have 'clickable' controls so that might help.

    How are you outputing your current report to Outlook? As a Snapshot ?

    A 'low tech' solution would be to use Ctrl+P to open the print dialogue select you page/pages then output to PDF 'printer' but then you may have to manually attach these to an email.

    VisageSoft eXPert PDF software (free download) allows you to append directly to email instead of saving to disc so this might help.

    S7

    Comment

    • barkarlo
      New Member
      • Nov 2006
      • 59

      #3
      Originally posted by sierra7
      Hi

      What version of Access are you using?? I hear in 2007 you can have 'clickable' controls so that might help.

      How are you outputing your current report to Outlook? As a Snapshot ?

      A 'low tech' solution would be to use Ctrl+P to open the print dialogue select you page/pages then output to PDF 'printer' but then you may have to manually attach these to an email.

      VisageSoft eXPert PDF software (free download) allows you to append directly to email instead of saving to disc so this might help.

      S7
      When I go to File and select Send to I open Send windows where I must select format.
      I choose snapshots format and press OK then All page from report sent to Outlook.
      I would like send only current page.
      I see too on right corner in Send windows Output (All or Selection) option but I have not access.
      My version is Access 2003.

      Comment

      • sierra7
        Recognized Expert Contributor
        • Sep 2007
        • 446

        #4
        The option to send Selection or All is activated when you are able to select a part of your document. For instance if you open a Table you can select the first 100 rows and send as a Snapshot document as a 'selection' or the whole table.

        It's not much use in a report though as you can't select pages. Even if you save the SNP file, either by the Export option or programmaticall y with DoCmd.OutPutTo, you still cannot divide up the report into pages other than using the Printer software. A challenge for sombody perhaps??

        I've searched for the Object Model of a Snapshot document but have drawn a blank so far.

        I'm out of ideas now other than using the PDF route.

        Sorry

        S7

        Comment

        Working...