By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,213 Members | 1,083 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,213 IT Pros & Developers. It's quick & easy.

Send Email by Clicking Email Address... Why so hard?

P: 9
Can anyone tell me how to either create a doubleclick event or a command button that will start an MS Outlook email (default client) to the ContactEmail1 control?

I cannot figure out how to start an Email that already includes the contact's email address.

Thanks.

- D

PS: A2k
Sep 20 '07 #1
Share this Question
Share on Google+
6 Replies


Denburt
Expert 100+
P: 1,356
O.K. if we start with the table and make sure the field type is set to hyperlink then we can simply type the following into the field and it works:
Mailto:1@2.com

Any questions?

Does this help?
Sep 20 '07 #2

P: 9
O.K. if we start with the table and make sure the field type is set to hyperlink then we can simply type the following into the field and it works:
Mailto:1@2.com

Any questions?

Does this help?

I guess that's one way to accomplish it. It ain't pretty, but it's functional.

Thanks.
Sep 20 '07 #3

Denburt
Expert 100+
P: 1,356
No not pretty but functional there are probably 1001 ways to get from point A to point B but I wanted to get you some results. A lot depends on your capabilities and I don't have a clue as to how much if any VBA you can understand. BTW you didn't give us any info on your attempts that tried and or failed so I have no idea what you REALLY want or what you can do.

I can take any text box use the double click event or any other event I prefer then something like (off the cuff)

hyperlink.follow ("mailto:" & me!MyTextBox)

It's a rough untried solution but something like that should be sufficient.
Is that any better?

Would you like a few more... No not time for a beer I'm out. I will be checking in so let me know if that ones better, if not give me something you have tried and maybe why it isn't working for you (usually helps your questions get the quickest most appropriate solutions).

Then I should be able to offer more assistance.
Glad I could help let us know how things go.
Sep 20 '07 #4

P: 9
No not pretty but functional there are probably 1001 ways to get from point A to point B but I wanted to get you some results. A lot depends on your capabilities and I don't have a clue as to how much if any VBA you can understand. BTW you didn't give us any info on your attempts that tried and or failed so I have no idea what you REALLY want or what you can do.

I can take any text box use the double click event or any other event I prefer then something like (off the cuff)

hyperlink.follow ("mailto:" & me!MyTextBox)

It's a rough untried solution but something like that should be sufficient.
Is that any better?

Would you like a few more... No not time for a beer I'm out. I will be checking in so let me know if that ones better, if not give me something you have tried and maybe why it isn't working for you (usually helps your questions get the quickest most appropriate solutions).

Then I should be able to offer more assistance.
Glad I could help let us know how things go.

The problem I was facing is that it tries to open up "http://mailto: 2@3.com"

I haven't tried the "mailto:" argument yet. Wouldn't one assume that Access would be able to recognize an email address and make it hot to generate an Outlook email?
Sep 21 '07 #5

P: 9
The problem I was facing is that it tries to open up "http://mailto: 2@3.com"

I haven't tried the "mailto:" argument yet. Wouldn't one assume that Access would be able to recognize an email address and make it hot to generate an Outlook email?
I get an Object Required error:

Private Sub ContactEmail2_DblClick(Cancel As Integer)
Hyperlink.Follow ("mailto:" & Me!ContactEmail2)
End Sub

Any ideas?
Sep 21 '07 #6

Denburt
Expert 100+
P: 1,356
Hyperlink.Follow Is used if the control you are pointing to has a hyperlink assigned to it.

Try using the FollowHyperlink Method, if you are in the VBA window highlight FollowHyperlink and press F1 that should help some. Let us know how things go, I will be more than happy to help.
Sep 21 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.