Basic emailing from access in either table or form 1

[tontenn]

Hi Guys

Im am really struggling. I have searched and tried every basic thread in here to try and sort out my problem but I just cant get ont to work that doesnt give me an error message. Not being that ofay with all your technical jargen doesnt help either.

Basically all I want to know and do is enter email addresses into my database under field name "email1" and to make it possible that when the email address shows up in the form that you can click on it(or press a button aligned to the email address) and it will then open into outlook to be populated and sent as an email.

I dont understand why access have made it so difficult. Shouldnt it just come up as a hyperlink in the table or form when you type in the email address just in every other microsoft program.

Sorry getting frustrated and really hope someone has a very basic way of doing what i need.

Thanks in advance from Melbourne Australia.

Tony

 

[malbreht]

Sorry, just to make sure: what's the data type of the field email1? If it's not Hyperlink...it can't work, can it?

However, you do need to be a little careful when typing e-mail, because in my case Access often makes a

http://www hyperlink.

So do check the properties...CTRL+K I suppose.

Mare from cold, cold Slovenia, brrr

 

[malbreht]

Oh, but don't change the data type to Hyperlink if you're planning to use the data with other applications, e.g. Word merging...

http://msdn2.microsoft.com/en-us/library/aa167323.aspx

 

[tontenn]

Thanks guys for those thoughts but yeah I am back to the basics on this one.
When i change the field type to Hyperlink it puts all the emails onto a hyperlink but when you click tries to open the link up in internet explorer and not in outlook.

Is there a way of making it open in outlook instead.
Remember Im a novice.

Thanks in advance

Tony

 

[PHV]

In the DoubleClick event procedure of your email1 control:
Application.FollowHyperlink "mailto:" & Me!email1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tontenn]

Thanks PHV, great idea and I think im getting closer but its still opening up internet explorer.

Let me get the instructions correct.

In my table i change the field type of email1 to hyperlink.

In my form i go into properties and place

Application.FollowHyperlink "mailto:" & Me!email1
in the line where it says "On Dbl Click"

then it should work is that correct or have i missed a step or put something in the wrong hole along the way.

Thanks in advance

Tones

 

[PHV]

1) change the field type of email1 to text
2) "On Dbl Click" choose event procedure, then click the ellipsis (...) and type the code I suggested in the VBEditor.


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[tontenn]

Oh thank you so very very very much PHV, you sre a GEM. (That means really great in Australia).

Once again a great results

Cheers

Tones