Results 1 to 2 of 2
Thread: Sending email from Access (2003)
2006-03-13, 16:50 #1
- Join Date
- Nov 2002
- South Carolina, USA
- Thanked 0 Times in 0 Posts
Sending email from Access (2003)
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.
2006-03-13, 17:02 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Sending email from Access (2003)
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:="firstname.lastname@example.org", Subject:="Order confirmation", _