Sending email from Access (2003)

Topic

New Reply

I need some help getting started on this part of a project. I have a database that users request information by entering some fields on a form. Once they click on submit, I want to send an email to them as well as the project leader confirming the request. We use Lotus Notes. I think I will use the sendobject command but I am lost. If at all possible, I would like to add this form on our website as well.

Please provide some directions.

Reply | Quote

Replies

If you want to send just some text, you can do it like this (the names are just examples)

Dim strMsg As String
strMsg = “Dear customer,” & vbCrLf & vbCrLf & _
“This e-mail is to confirm your order for ” & Me.txtQuantity & ” widgets, dated ” & _
Me.txtOrderDate & vbCrLf & vbCrLf & “Yours sincerely,” & vbCrLf & “Deborah P.”
DoCmd.SendObject To:=Me.txtEmail, Cc:=”john@company.com”, Subject:=”Order confirmation”, _
MessageText:=strMsg, EditMessage:=False

Reply | Quote