Generate e-mail using data in the table

[sreejith]

Hi everybody,

I need to generate an e-mail to a particular ID using the
data regarding the installation of new component. To be
more clear, whenever a new product is issued to the user
in the company or replaced with a new one, I will be
updating a table in access with the device IDand serial no
of the device and user ID. what i want is the program
should recognize when the table is being updated and
should generate an email to our purchase manager.

Please give me some guidelines regarding this

- Thanking you in anticipation
- Sreejith

 

[Arvin Meyer]

What you require is a Trigger. Triggers are only available with
client/server databases such as the MSDE or SQL-Server. An Access MDB does
not have triggers and is therefore incapable of what you want.

You can, however, use a form event to send email when the form updates the
table. The easiest method is to use SendObject which is built right into
Access. You can also open an Outlook session, code for which is on my
website:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access