Aug 10 2004, 04:56 PM
How do I create a field in a form or table that when I enter data it will make it a link that will open my mail program and create a email for this address. I am using Access 2000
Aug 10 2004, 05:09 PM
Look up sendobject in help. You can use it on after update of the field or create a command button that will execute the command, it is preferred to use the command button gives you the chance to review before sending. the sendobject will create an attachment in an email when used.
If you need more help just ask.
Aug 10 2004, 05:38 PM
I looked at the sendobject help but it did not seem to help.
I am wanting to create a field in a form that when someone registers for a conference and send me on hardcopy their email address I can add their email address in my form and then when I want to communicate with them later I can just go to their email address on the form click on it and have it open an email to them. I am using Access 2000 and Outlook 2000. Hope this is clearer:)
Aug 11 2004, 03:58 PM
In what way is the individual regisrating, web or by form through the same db that you are accessing or is there a seperate db that is being used for registration?
Aug 11 2004, 04:09 PM
They register with me on a paper form. Then I take the information off the form and put it into the DB. They do not have access to the DB.
Aug 12 2004, 06:55 PM
I believe i have it for you. You will need to use a command button and you can use this code to open an email message with the address in the to section.
Private Sub Command3_Click()
Application.FollowHyperlink "mailto:" & Me.Text1
Of course you will need to modify it to you specifications.
Aug 12 2004, 07:01 PM
Thanks I will give this a run and see if it works.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here