Glenn
Care to wager on how long it takes the boss to say "Uncle"? [smile]
I had this exact request a few years ago. The "every change" soon became "number of changes each day" to finally "Never mind".
Bill
--- In MS_Access_Professionals@yahoogroups.com, "Glenn Lloyd" <argeedblu@...> wrote:
>
> The devil in me says make sure you give the boss exactly what he asked for.
> However, use this advice with caution. Being flooded with emails may just
> sharpen the bosses skills in learning to know what he really needs and how
> best to ask for it.
>
>
>
> Glenn
>
>
>
>
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: April-13-12 10:50 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: E-mail on Change
>
>
>
>
>
> Dan
>
> While this isn't impossible, does your boss realize how many emails he's
> going to get?
>
> Use each form's AfterUpdate event to send an email using DoCmd.SendObject.
>
> But I bet he changes his mind after just one week. This being my prediction,
> you should use a global constant Boolean to determine if the email should be
> turned on or off.
>
> In a standart module, put this in the general declaration area:
> Public Const gcbolSendEmail As Boolean = True
>
> Now add this public Sub in the same module
> Public Sub SendEmail()
> If gcbolSendEmail = True Then
> DoCmd.SendObject ObjectType:=acSendNoObject, _
> To:="myBoss@... <mailto:myBoss%40myCompany.com> ", _
> Subject:="Another update", _
> Message:="Do you give up yet?", _
> MessageEdit:=False
> End If
>
> End Sub
>
> Then in each form's AfterUpdate event put this code:
> Private Sub Form_AfterUpdate()
> Call SendEmail
> End Sub
>
> Edit the code in SendEmail to match your boss's email address, the message,
> etc. so it reads the way you want it to.
>
> When he starts yelling, "STOP THOSE BLASTED EMAILS!!!" you can set the
> global constant to False.
>
> Regards,
> Bill Mosca, Founder - MS_Access_Professionals
> http://www.thatlldoit.com
> Microsoft Office Access MVP
> https://mvp.support.microsoft.com/profile/Bill.Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , Dan Fielding
> <amessyguy@> wrote:
> >
> > Is it possible to send an e-mail via Outlook to a specific user every time
> a record in a database has been changed, deleted, or updated?
> >
> > My boss would like to receive a simple notification that a change has been
> made. The actual update/addition that took place isn't important, just the
> fact that there was an update/addition.
> >
> > I guess there are two types of procedures that might be possible here.
> One would be an e-mail notification each time any change is made (possibly
> generating a lot of e-mail messages). The other would be one e-mail no
> matter how many changes took place during that editing/updating session. I
> think to make things easier I would prefer that the boss get one e-mail
> stating that changes have been made, regardless of how many changes there
> were.
> >
> > If this is too difficult, is there some other method you all use to do
> something similar that doesn't involve e-mail?
> >
> > Dan
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar