sending e-mail from Access

[Anna Yevsiyevich]

Hi All,
Is it possible to send out an e-mail notifying of a change to the database?
Basically, I have a table into which data gets enetered every once in a
while (it's a web form). When a new record is added, I'd like to send out a
notification to people to go see the new changes. Is this possible?
If yes, how?

Any help would be greatly appreciated.

Thanks,
Anna

 

[Douglas J Steele]

Access doesn't have that ability built into it. You'd have to put logic into
your web form to send the e-mail.

 

[Anna Yevsiyevich]

Thanks Doug.
Is there another way to notify people that a change has occured in the
database?

(Basically, I need people to know that someone has filled out our "Contact
Us" form from the webpage. The data that is entered is stored in the
database, and I want to make sure we don't let the data sit there for a
month before contacting the person.)

Thanks for your help,
Anna

 

[Jack G]

Anna,

I've seen a number of posts in the past that say you can't do this, but I
think it's pretty simple (maybe this was a new feature that snuck in
unnoticed in 2003?).

Every time someone in our office adds a new 'project' to our database, an
email is created automatically (although the person who changes the database
must click the send button to complete the task).

We do it by assigning a macro to the AfterInsert event in the form where the
new project is created. The Macro has one Action: SendObject. The
arguments we use are as follows:

Output Format: HTML
To: (e-mail address removed)
Subject: New Project Started
Message Text: ="A new project, " & [Forms]![DetailsForm]![ProjectNumber]
& ", " & [Forms]![DetailsForm]![ClientName] & ", " &
[Forms]![DetailsForm]![ProjectName] & " has been created by " &
[Forms]![DetailsForm]![ProjectMgr]

So after a new project is added, the email pops up already filled in, and
the user can add comments if desired and then click Send.

Jack

 

[Anna Yevsiyevich]

Hi Jack,
Thanks for the reply!

Do you know if there is an automatic way of sending an e-mail? I want to
eliminate the need for human eyes in this process.

Thanks,
Anna

Anna,

I've seen a number of posts in the past that say you can't do this, but I
think it's pretty simple (maybe this was a new feature that snuck in
unnoticed in 2003?).

Every time someone in our office adds a new 'project' to our database, an
email is created automatically (although the person who changes the
database must click the send button to complete the task).

We do it by assigning a macro to the AfterInsert event in the form where
the new project is created. The Macro has one Action: SendObject. The
arguments we use are as follows:

Output Format: HTML
To: (e-mail address removed)
Subject: New Project Started
Message Text: ="A new project, " &
[Forms]![DetailsForm]![ProjectNumber] & ", " &
[Forms]![DetailsForm]![ClientName] & ", " &
[Forms]![DetailsForm]![ProjectName] & " has been created by " &
[Forms]![DetailsForm]![ProjectMgr]

So after a new project is added, the email pops up already filled in, and
the user can add comments if desired and then click Send.

Jack

Access doesn't have that ability built into it. You'd have to put logic
into
your web form to send the e-mail.

 

[Douglas J Steele]

How is that any different than my comment that you need to logic to send the
e-mail?

That's what your macro does!

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Anna,

I've seen a number of posts in the past that say you can't do this, but I
think it's pretty simple (maybe this was a new feature that snuck in
unnoticed in 2003?).

Every time someone in our office adds a new 'project' to our database, an
email is created automatically (although the person who changes the database
must click the send button to complete the task).

We do it by assigning a macro to the AfterInsert event in the form where the
new project is created. The Macro has one Action: SendObject. The
arguments we use are as follows:

Output Format: HTML
To: (e-mail address removed)
Subject: New Project Started
Message Text: ="A new project, " & [Forms]![DetailsForm]![ProjectNumber]
& ", " & [Forms]![DetailsForm]![ClientName] & ", " &
[Forms]![DetailsForm]![ProjectName] & " has been created by " &
[Forms]![DetailsForm]![ProjectMgr]

So after a new project is added, the email pops up already filled in, and
the user can add comments if desired and then click Send.

Jack

Access doesn't have that ability built into it. You'd have to put logic
into
your web form to send the e-mail.

 

[Jack G]

If you say 'No' in the 'Edit Message' line of the Send Object arguments, the
email will go straight through. However, depending on what the security
settings are for your email program or computer, the sender may be warned
that 'a program is trying to automatically send email on your behalf. Do you
want to allow this?'

You might be able to adjust your security settings to stop showing the
message if you're sure you're not exposing yourself to some other danger.

Jack

Hi Jack,
Thanks for the reply!

Do you know if there is an automatic way of sending an e-mail? I want to
eliminate the need for human eyes in this process.

Thanks,
Anna

Anna,

I've seen a number of posts in the past that say you can't do this, but I
think it's pretty simple (maybe this was a new feature that snuck in
unnoticed in 2003?).

Every time someone in our office adds a new 'project' to our database, an
email is created automatically (although the person who changes the
database must click the send button to complete the task).

We do it by assigning a macro to the AfterInsert event in the form where
the new project is created. The Macro has one Action: SendObject. The
arguments we use are as follows:

Output Format: HTML
To: (e-mail address removed)
Subject: New Project Started
Message Text: ="A new project, " &
[Forms]![DetailsForm]![ProjectNumber] & ", " &
[Forms]![DetailsForm]![ClientName] & ", " &
[Forms]![DetailsForm]![ProjectName] & " has been created by " &
[Forms]![DetailsForm]![ProjectMgr]

So after a new project is added, the email pops up already filled in, and
the user can add comments if desired and then click Send.

Jack

Access doesn't have that ability built into it. You'd have to put logic
into
your web form to send the e-mail.

Hi All,
Is it possible to send out an e-mail notifying of a change to the
database?
Basically, I have a table into which data gets enetered every once in a
while (it's a web form). When a new record is added, I'd like to send
out
a
notification to people to go see the new changes. Is this possible?
If yes, how?

Any help would be greatly appreciated.

Thanks,
Anna

 

[Ron2006]

Another option is if there is a date or something in the table that
indicates when the record was added.

If so then periodically run a query, and other code to send out email
if there have been any records added since the last time that this
query has been run. Run it once a week for prior week. Once a day for
prior day. or whatever other criteria you decide on.

 

[dbahooker]

screw MDB this would be a single line of code in SQL Server

 

[Terry Kreft]

From this and other posts I suspect you're just a troll, but there is the
possibilty that you're actually incompetent and prefer to blame the tool.

Even whn you offer a piece of technical advice you're wrong.