email addresses within forms

  • Thread starter Thread starter andy_lucas
  • Start date Start date
A

andy_lucas

Guest
Is there any way in which I can have an email address for a particular field displayed on a form that can then be clicked upon (as a hyperlink) to open Outlook Express with a new message with the 'To:' part containing that address.

Cheers
 
Try this: mailto:emailaddress?subject=putsubjecthere.
smile.gif
 
You can do a lot with VBA's SendObject. Here is an example:

Put this behind the comand button:

DoCmd.SendObject , , , Me.txtEmail, , , "YourSubject", "BodyText", True

Then just replace the Me.txtEmail with Me.YourTxtBox that holds the email address.

If you want to use a subject line, or message text from a control (text box) you can substitute: (note the absense of the quotes when you use Me.AnyThing)

"YourSubject" with Me.YourSubject (replace your subject with your text box name)

"BodyText" with Me.YourText (This will be put in the body of the message)

[This message has been edited by BukHix (edited 01-30-2002).]
 
You can also as a simple way of doing it use:

Application.FollowHyperlink "mailto:" & Me.EmailField
 
This is a field (ClientEmail) that contains an email address. (I have set it as Hyperlink) do I double click on that and type this code? Sorry to sound dumb but I am a real novice
 

Users who are viewing this thread

Back
Top Bottom