Customers Email

[will]

I have a field where I enter customers e-mail address. Later, I would like to use the mail address as a link from my main form to open up Outlook and automatically insert the name into the Address field. I have a text box whose control source is on the email field of my table, but it treats the email address as if it is a web address and puts "http://" as if the email address is acutally a URL. How do I format it to open Outlook and insert the email into the address field? Has anyone had this problem, and how do I fix it?
Thanks

 

[simongallop]

Make the email field in the table a normal text field. Then on the OnClick event of the textbox {am calling it txtEMail} have:

Dim Recip
Recip = me.txtEMail
Docmd.SendObject ,,, Recip,,,,,True

Check the help on Docmd.sendobject

HTH

 

[will]

Hey thanks, that works..sort of..I get this in the Address of Outlook when the program opens:

To: zizhuang@hotmail.com#http://zizhuang@hotmail.com#

any ideas about that last part? I need to remove everything from the # sign on...Thanks!