Create email with a command button

[clackl]

We have a database which we use to accept referrals from a peripheral source. They fill in the form with all the referral details, then send an email via outlook to let us know that the details have been entered into the database. Is there a way of using a command button on the access database form to automatically generate an email to let us know that the data has been entered?

 

[PHV]

Take a look at the DoCmd.SendObject method

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ZmrAbdulla]

Have an advanced search on the topic in these forums.. You will sure find many posts and answers..


Zameer Abdulla
_{Jack of Visual Basic Programming, Master in Dining & Sleeping}
Visit Me