Is it possible to?

[Guest]

i have an event management database, is it possible that when i register
someone onto an event that i can send an email out to them to confirm they
have a place. at the moment i register them and then send them an email
manually.

 

[Douglas J Steele]

Take a look at the Microsoft Access Email FAQ Tony Toews has at
http://www.granite.ab.ca/access/email.htm

 

[Guest]

Thanks for your speedy reply. i have checked out the website and being new
to access this seems to go over my head, is there an idiots giude on how to
set it up

 

[Douglas J Steele]

Realistically, you need to use VBA to do this. You'll have to learn
something about that in order to accomplish your end result.

 

[Guest]

Thanks again, for your reply

i have had a go at coding this is what i came up with

Private Sub Command1361_Enter()

Dim dbs As DAO.Database
Dim rst As Recordset
Set rst = dbs.OpenRecordset("Email_query", dbOpenSnapshot)

DoCmd.SendObject , , acFormatTXT, [EmailName], , , "Confirmation of Place on
Course", "Dear " & rst![AttendeeFirstName] & "I can confirm you have a place
on the: -" & rst![EventName] & "Start Date" & rst![StartDate] & "Thank you
for your application Phil"
& ", 0,,"

there is obviously something wrong as it does not work but i have hit a
brick wall

Email_query is the name of the query to get the data

i think the problem is at the end of the code, & ", 0,," is what shows up
as wrong i do not know why (this is my first time) i appreciate any help