Can MSAccess be programmed such that a chg to a record send mail? [WiredBox.Net

Group: Microsoft Access » microsoft.public.access.macros
Thread: Can MSAccess be programmed such that a chg to a record send mail?

DotNetBag
.NET Development Newsgroups

HTVi
TV Discussion Newsgroups

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10

Can MSAccess be programmed such that a chg to a record send mail?

Cheryl Garrison 14.07.2006 11:55:01

I'd like to know if a user changes specific fields in a record and have it
automated by receiving email to my Outlook mailbox. Can this be done. Perhaps
there's another way of invoking the detection of changed data in a record -
please disclose in specific terms.

RE: Can MSAccess be programmed such that a chg to a record send mail?

PeteyP 14.07.2006 14:03:01

Yes. Create a macro that uses the SendObject action. Others will probably
suggest that VB code be written using Docmd, but I don't know how to do that.
Also, search for the thread SendObject Macro (6/1/06) in this section to see
specific advice.

"Cheryl Garrison" wrote:

[Quoted Text]
> I'd like to know if a user changes specific fields in a record and have it
> automated by receiving email to my Outlook mailbox. Can this be done. Perhaps
> there's another way of invoking the detection of changed data in a record -
> please disclose in specific terms.

Re: Can MSAccess be programmed such that a chg to a record send mail?

"Joseph R. Pottschmidt" <me[ at ]joepottschmidt.com> 14.07.2006 18:55:53

This is a multi-part message in MIME format.

------=_NextPart_000_0058_01C6A73C.74A49FA0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Dear Cheryl:

Do you want to be able to make changes to a record in the database from
an email that is sent to your Inbox of your Outlook, or do you want to
receive an email anytime a record is changed in the database?

-----Original Message-----
From: Cheryl Garrison [mailto:Cheryl Garrison[ at ]discussions.microsoft.com]

Posted At: Friday, July 14, 2006 4:55 AM
Posted To: microsoft.public.access.macros
Conversation: Can MSAccess be programmed such that a chg to a record
send mail?
Subject: Can MSAccess be programmed such that a chg to a record send
mail?

I'd like to know if a user changes specific fields in a record and have
it
automated by receiving email to my Outlook mailbox. Can this be done.
Perhaps
there's another way of invoking the detection of changed data in a
record -
please disclose in specific terms.

------=_NextPart_000_0058_01C6A73C.74A49FA0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7036.0">
<TITLE>Re: Can MSAccess be programmed such that a chg to a record send =
mail?</TITLE>
</HEAD>
<BODY>


Dear Cheryl:


Do you want to be able to make changes to a record in =
the database from an email that is sent to your Inbox of your Outlook, =
or do you want to receive an email anytime a record is changed in the =
database?
 
 

-----Original Message-----

 From: Cheryl Garrison [<A =
HREF=3D"mailto:Cheryl">mailto:Cheryl</A> =
Garrison[ at ]discussions.microsoft.com] 

 Posted At: Friday, July 14, 2006 4:55 AM

 Posted To: microsoft.public.access.macros

 Conversation: Can MSAccess be programmed such that a =
chg to a record send mail?

 Subject: Can MSAccess be programmed such that a chg =
to a record send mail?


I'd like to know if a user changes specific fields in =
a record and have it 

 automated by receiving email to my Outlook mailbox. =
Can this be done. Perhaps 

 there's another way of invoking the detection of =
changed data in a record - 

 please disclose in specific terms.


</BODY>
</HTML>
------=_NextPart_000_0058_01C6A73C.74A49FA0--

Home | Search | Terms | Imprint | Contact

Newsgroups Reader - provided by WiredBox.Net