Email

[PamB]

I have created a simple Access database that our HR department will use to
input demographic information on a new employee, as well as what software,
access, etc. a new employee will need. Again, it is VERY simple, but what I
can't figure out is how to create a button that the HR staff can click on and
the file, with all the information, is emailed to our IS department. Can this
be done?

 

[Daniel Pineault]

You can setup a report to based on your current record and email it using
SendObject or using Outlook automation. This does require a minimal amount
of VBA programming in either case. If you search this forum you will find
numerous post on both of these subjects.

If you don't want to e-mail a report you could automate outlook (without an
attachement) and simply pass the control values directly into the message
body. It depends on your needs, quantity of data to transfer and whether or
not the person at the other end need to simple view the info or if they need
to be able to manipulate (copy/paste) into there system.

Post back with more details if you would like further help.
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.