Hyperlink

[Guest]

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!

 

[Guest]

Look at this post, a similar question been answered by Gunny (69 camaro)

http://www.microsoft.com/office/com...ding&mid=83fd8c8c-1b45-48ef-b3c8-82a45b3dab4e

 

[Guest]

Thanks, Ofer.
I looked at this info and couldn't quite get it to work. I posted a reply
to Gunny (69 camaro), but perhaps no one is tracking that post any longer.

Here's my post:
http://www.microsoft.com/office/com...ding&mid=83fd8c8c-1b45-48ef-b3c8-82a45b3dab4e

Do you have any suggestions?
Thanks

 

[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 (e-mail address removed) 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.

 

[Guest]

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

You can make a new contacts table with a hyperlink emai address. If the
addresses are already in the form (e-mail address removed) 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]

 

[Guest]

Actually, I used DoCmd.SendObject method and it worked just fine!

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

You can make a new contacts table with a hyperlink emai address. If the
addresses are already in the form (e-mail address removed) 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][/QUOTE]