E-mailing from an access form

[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.

 

[Scott McDaniel]

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

 

[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.