Send an email to a contact with no attachment

[KAquestions]

Hi all,

My database collects contact details. I'd like to set it up so that when the
user clicks the email address field, it opens up a blank outlook email for
that contact.

I think years ago i have done it using send object - but this time there's
nothing to send?

Can anyone help?

Kirstie

 

[KAquestions]

Thanks Bonnie will give it a try.

How do i reference a particular field for it to get the email address?

Kirstie

 

[KAquestions]

this is what i have currently, but isn't working:

Private Sub EmailAddress_Click()
DoCmd.SendObject , , , Me.EmailAddress, , "message subject", , , True
End Sub

your help is much appreciated!

Thanks Bonnie will give it a try.

How do i reference a particular field for it to get the email address?

Kirstie

 

[KAquestions]

I am just trying to send to one contact.

Kirstie

Are you sending the email from a form? If so you can refer to the control
on
the form that contains the email address.

Do you want to send just one or loop through a table? Here's a link:

http://www.granite.ab.ca/access/email/recordsetloop.htm

Bonnie
http://www.dataplus-svc.com

Thanks Bonnie will give it a try.

How do i reference a particular field for it to get the email address?

Kirstie

Hi Kristie,

[quoted text clipped - 16 lines]

Kirstie

 

[KAquestions]

Thanks for that, i'll give it a try. And will def use a button instead.

K

 

[KAquestions]

Hi Pisteuon,

It worked perfectly, many thanks.

K

Thanks for that, i'll give it a try. And will def use a button instead.

K

I suggest using a button next to the field, if you use the field itself,
later when you go to change an email address, it will keep opening a new
email.

Private Sub Command1_Click()

Dim mail As String

mail = [EmailAddress].value

[Command1].HyperlinkAddress = "mailto:" + mail

End Sub