Simple Email

[travismp]

I have a simple form and simple table.

I want the database to automatically email me when someone enters information into the form

Is this possible? Thanks

 

[KeithG]

Is this form stirctly for data entry? If so you could add a button called submit and have the button save the new record and then use docmd.sendobject to send an email. The user will be prompted wether or not they want the email to be sent though. This is a feature built into Outlook and the only way around it is to use the Redemption.dll to send an email without the warnings.

 

[travismp]

Yes it is data only.

I too found the "docmd.sendobject" out I did not like the prompting on the user end.

Any other thoughts or options?

 

[KeithG]

The only way to bypass the user prompts is to download Outlook redemption. Below is a URL to download it!!

http://www.dimastr.com/redemption/home.htm

 

[greaseman]

The Redemption program is not the only way to bypass user prompts. Go to the following site, http://www.ContextMagic.com. There is a program there called "Click Yes" that allows the user prompts to be bypassed.

I've used it for months now and it works very well.