Hyperlink

S

Stephanie

Hi. I've created a form- sort of a "rolodex"- that shows member's names,
addresses, phone #s, and email addresses.

Just curious- could I make the email address a hyperlink so when I click on
the email address, a new Outlook email will open with the Access email
address in the To column? If this is a possibility, I'd apreciate details.
Thanks!
 
B

Bob M via AccessMonster.com

You can make a new contacts table with a hyperlink emai address. If the
addresses are already in the form [email protected] then create the following make
table query and run it:
SELECT Contact.[Name], Contact.email, "Mailto:" & AS contac INTO
contac
FROM Contact;

Of course, add al the other Contact].fields from the table.
Open the contac table in design and change the email field to Hyperlink type.
Delete the old contacts file and rename the contac to Contacts.
When the email field is selcted in the form it will immedately go to your
email compose with the address.
 
S

Stephanie

Thanks, Bob.
Hmm. I'm not using this form for entry- it's just a rolodex form that shows
contact info, including email address.
When I click on the already populated email address, I want Outlook to open
with the email address populated in a new email (subject line blank).

Thanks,
Stephanie

Bob M via AccessMonster.com said:
You can make a new contacts table with a hyperlink emai address. If the
addresses are already in the form [email protected] then create the following make
table query and run it:
SELECT Contact.[Name], Contact.email, "Mailto:" & AS contac INTO
contac
FROM Contact;

Of course, add al the other Contact].fields from the table.
Open the contac table in design and change the email field to Hyperlink type.
Delete the old contacts file and rename the contac to Contacts.
When the email field is selcted in the form it will immedately go to your
email compose with the address.
[QUOTE]
Hi. I've created a form- sort of a "rolodex"- that shows member's names,
addresses, phone #s, and email addresses.

Just curious- could I make the email address a hyperlink so when I click on
the email address, a new Outlook email will open with the Access email
address in the To column? If this is a possibility, I'd apreciate details.
Thanks![/QUOTE]
[/QUOTE]
Click to expand...
 
Top