Printable View
I have a table that multiple users can update it via filling a form and emailing it. I have another table with the users details including the email address.
I want to send an automatic confirmation email so that the user knows that the data they have sent has been captured and updated in the database. I was trying to use the after insert event feature in access 2010 but as i am not so well versed i need help.
Richlyn, welcome to ExcelFox
You might want to tell how your table gets updated just by emailing a form.
Did you try the e-mail codes provided in this forum?
I am using Access 2010.
I use the feature "Create Email" to "collect data" and then when users reply by filling the form in the sent email the table is updated with a new record.
I just want to send the user a email for confirmation stating that their data has been updated in the table and also mention what they had filled in the form for validation purposes.
Where do i find the e-mail codes. Sorry to ask such a stupid Q though.Quote:
Originally Posted by Excel Fox
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgxesLhWNr_zNP0GUdh4AaABAg. 9hI1CQJMLLo9hWn2pGBeSS
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgzkRujoMw9PblmXDQ14AaABAg. 9hJRnEjxQrd9hJoCjomNI2
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgzPZbG7OvUkh35nXDd4AaABAg. 9hJOZEEZa6p9hJqLC7El-w
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgwUcEpm8u6ZW3uOHXx4AaABAg. 9hIlxxGY7t49hJsB2PWxC4
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgyvDj6NWT1Gxyy2JyR4AaABAg. 9hIKlNPeqDn9hJskm92np6
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=Ugwy7qx_kG9iUmMVO_F4AaABAg. 9hI2IGUdmTW9hJuyaQawqx
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgxesLhWNr_zNP0GUdh4AaABAg. 9hI1CQJMLLo9hJwTB9Jlob
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgyyQWYVP1OnCqavb-x4AaABAg
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=UgwJKKmExZ1FdZVDJf54AaABAg
https://www.youtube.com/watch?v=pkhazgI3LAo&lc=Ugz_p0kVGrLntPtYzCt4AaABAg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgyG714V_k7odQMrTz14AaABAg. 9h740K6COOA9iHOYYpaAbC
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgxuL6YCUckeUIh9hoh4AaABAg
https://www.youtube.com/watch?v=2oT4qrHmDMY&lc=UgwGTEyefOX7msIh1wZ4AaABAg. 9h4sd6Vs4qE9h7G-bVm8_-
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
I have made a after insert event using the Access GUI feature which looks like this.
Attachment 183
I am not able to populate the email address in the to field which needs to picked up from a referenced table.
Okies i got that fixed after a lot of googling and asking help from coleagues..
Hi richlyn,
Could you please share the solution here ?
here is the code that i used in the access 2010 UI macro event...