sending the contents of a form to an email address

[Guest]

Hi,

I have created a DB which I am ready to put onto our network in a Beta
state. I would like to create a simple table within the DB to keep track of
problems that users experiance. So I would like to create a form with the
fields from the table and when the user clicks Save, the data is written to
the Table, BUT also an email is automatically sent to a pre-defined email
address, with the contents of the form the user has just filled in. Is there
is a simple way to do this I would appreciate the advice. If it can only be
done using VBA, I would REALLY REALLY appreciate someone sending me the code
to do it.

Thanks

 

[Rick B]

Do a search. There are tons of threads out there on this topic.

For one, read the Thread in the Microsoft.Public.Access newsgroup started
yesterday. The Subject is "Emailing Access Database Form".

 

[Guest]

Hi Rick,

Thanks for your guidance. I did do a search using my subject and it did not
come up with anything, so I thought I was unique

I have followed your discussion with Roxanne and I have even managed to
surprise myself. I managed to get it to work!

Is there anyway that the email is automatically sent? Currently I have
created the email, but an Email still opens and the user would need to select
send. Ideally i would like this all to happen behind the scenes.

Thanks for your time to answer these question.

Regards

Tony

 

[Rick B]

I think one of the last arguments in the sendobject command is "edit" or
something similar? That setting lets you click the SEND, or have it go by
itself.

Use the help files to see if you can find it.

I have done it before, but I don't have access to that database at the
moment.

 

[Guest]

Hi Rick,

Thanks again for your responses. I have managed to get everything working
perfectly EXCEPT the Outlook security warning that pops-up when you send
the email via the code. Is there anyway of by-passing it? I read a little
about "Sandbox" don't fully understand it, but would it help in this
situation?

Thanks

Tony