In my Access 2000 database I made some fill in forms for the user.
When the user fills in a new form or changes an existing form then he/she needs to save this form. After saving the form the database opens also an email (to send to me/owner database).
The user has to type text and title of the email and send the email by him/herself. That's not what I want !!!
So my questions are:
Is it possible to write the title of the email and the text(=email) in VBA ? So that the user doens't have to type/do nothing ? And how will that be done/possible ?
And is it possible to do this all at the background, so that the user doesn't see/notice anything ? That means that the click on the emailbutton must be automated into the VBA code I suggest ? Is this also possible, and how will that be done then ?
I need some help to get this started !!!
When the user fills in a new form or changes an existing form then he/she needs to save this form. After saving the form the database opens also an email (to send to me/owner database).
The user has to type text and title of the email and send the email by him/herself. That's not what I want !!!
So my questions are:
Is it possible to write the title of the email and the text(=email) in VBA ? So that the user doens't have to type/do nothing ? And how will that be done/possible ?
And is it possible to do this all at the background, so that the user doesn't see/notice anything ? That means that the click on the emailbutton must be automated into the VBA code I suggest ? Is this also possible, and how will that be done then ?
I need some help to get this started !!!