Sending an e-mail containing a form from access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database wich we use in our bridal shop. At this moment we
phone the brides if the gown is ready. Nowadays has every bride an e-mail
adress so we could also send her an email.

Our employees work with a form I created in Acces. I now try to make a
button beside the brides email adress. The functionality of that button must
be the following: Outlook is started and a new email is made with the email
adres of the bride containing the record of the bride and a standard sentence
"your gown is ready, you can phone us at 54645646456 to make an appointment"

That would be great!
 
You can do this with DoCmd.SendObject. At a minimum you'd have something
like this in the button's Click event procedure:

Const MSG_TITLE = "Your gown is ready!"
Const MSG_SENTENCE= "Your gown is ready, you can blah blah"

Dim strMsg as String

strMsg = "Dear " & Me.FirstName & vbCrLf & vbCrLf _
& MSG_SENTENCE

DoCmd.SendObject acSendNoObject, , , Me.Email, , , _
MSG_TITLE, strMsg, True

This assumes that the email field is called "Email" and that the first
name field is "FirstName". Change the final True to False if you want
the message to be sent automatically without the user having the chance
to edit it.




On Sat, 6 Aug 2005 05:46:23 -0700, the bridal shop <the bridal
 
Back
Top