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

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.

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:)

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?

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.

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.


Of course you will need to modify it to you specifications.

Thanks I will give this a run and see if it works.