Xenix
10-09-2001, 01:08 AM
Hello, I want to have a customer email link that simply opens Outlook and places the address from the email field in it from my cutomer database form when I click on the field. Can anyone help me with this?
|
View Full Version : Email link on a Form Xenix 10-09-2001, 01:08 AM Hello, I want to have a customer email link that simply opens Outlook and places the address from the email field in it from my cutomer database form when I click on the field. Can anyone help me with this? BukHix 10-09-2001, 04:17 AM This will do it for you: DoCmd.SendObject , , , Me.Email, , , Me.Subject, "TextToSend", True This assumes that the Email and subject are going to be pulled from the database. Just rename the Me.Email and Me.Subject to match your controls name. You could also do the same thing with the "TextToSend" field. If you change the true at the end to a false the email will automaticaly be sent without a promt from the sender. There is a lot of different arguments that you can use to send email, if you have further questions or would like more help be specific with what you want to do including the relevant field/control names. ptaylor-west 10-09-2001, 06:50 AM You can also use this option as an On Click event, just rename the [E-mail Address] to what field name you used Dim StrInput As String StrInput = "mailto:" & Me![E-mail Address] Application.FollowHyperlink StrInput, , True |