Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

E-mailing from an access form

Discussion in 'Information Technology' started by Mr. Smiley, Jul 28, 2006.

  1. Mr. Smiley

    Mr. Smiley
    Expand Collapse
    Guest

    Hello. I have a questions about e-mailing from an access form. What I was
    hoping to create is a button a form that, when pressed, will take a
    screenshot, then open Outlook and paste the screenshot with a message that
    states "zero quantities". If anyone know how to accomplish this, please let
    me know. Thanks in advance.
     
  2. Loading...


  3. Scott McDaniel

    Scott McDaniel
    Expand Collapse
    Guest

    On Fri, 21 Jul 2006 04:26:01 -0700, Mr. Smiley <MrSmiley@discussions.microsoft.com> wrote:

    >Hello. I have a questions about e-mailing from an access form. What I was
    >hoping to create is a button a form that, when pressed, will take a
    >screenshot, then open Outlook and paste the screenshot with a message that
    >states "zero quantities". If anyone know how to accomplish this, please let
    >me know. Thanks in advance.


    Access doesn't do screenshots natively; you'll have to automate this somehow:

    http://support.microsoft.com/?kbid=240653

    This is a VB article, but should work with VBA as well.

    Once you do that, you'll need to automate Outlook to handle the rest. I've got an A2k sample on my website that shows
    how to do this:

    www.infotrakker.com/ProgSamples/OutlookEmail.zip



    Scott McDaniel
    scott@takemeout_infotrakker.com
    www.infotrakker.com
     
  4. Jeff C

    Jeff C
    Expand Collapse
    Guest

    As SCott says, Access willnot email forms or screen shots but the workaround
    I use is to save the form as a report. Open your form in designe mode and go
    to "file", "save as", and choose a report. Build a query to use as the
    record source for your report with criteria that specify the current record
    showing on your form. Add a command button that activates the "SendObject"
    specifying the report you just created and a report that basicvally resembles
    your form will be attached to an email. You will have a minimal amount of
    re-design to do on the report after you create it but this workaround is
    effective for some things.
    --
    Jeff C
    Live Well .. Be Happy In All You Do


    "Mr. Smiley" wrote:

    > Hello. I have a questions about e-mailing from an access form. What I was
    > hoping to create is a button a form that, when pressed, will take a
    > screenshot, then open Outlook and paste the screenshot with a message that
    > states "zero quantities". If anyone know how to accomplish this, please let
    > me know. Thanks in advance.
     

Share This Page