Email from a form

[scottie]

Hi again everyone.

I knew I would be back, well I have spent hour’s google-ing and looking through the forum for a solution, but none seem to cover what I am looking for.

I am no expert with “The Code” so please be nice :-)

I have a form and in it there is a field that contains an email address. What I would like to be able to do is click a command button that takes the email address and opens a blank email in outlook with the address already filled in for the record that is currently being displayed on the form.

I know that I can do it by making the corresponding field within the table a hyperlink and preceding the address with “mailto:” However the people that will ultimately be using the database will never remember to do that.

Any ideas or a pointer in the right direction would by gratefully received.

Thanks a million
Scottie

[hjozinovic]

hey scottie!

seems to me that you could use smart tags for this.
[HTML]Go to table containing the e-mail address.
Select the 'E-mail' field.
While selected (I presume it's text) go to lower window with the field properties
Click the Smart tag propertie and you'll get [...] at the end.
Click that to open the wizard and select Person name from the list.
Go to the form and select the E-mail control. At the end there should pop-up a flag-like [i].
Select 'send e-mail' from the list.[/HTML]

Note: if the field on the form dont change try to delete it and dragg it back again from the field list.

[scottie]

Hi hjozinovic,

Thanks for you prompt reply.

I have done as you say, but I can only get to point 3, as I don’t appear to have “smart tags”. I am using office XP Professional, if that makes any difference!!!!

And yes to point 3 it is in a text format.

I really do appreciate the help.

Thanks
Scottie

[scottie]

Sorry correction in is office 2002

[NeoPa]

Check out Outlook : Select Address of a Contact.

This is not a very straightforward subject I'm afraid, since the crackers have been using it to propagate their malware :(

[hjozinovic]

Unfortunatelly Smart Tags are introduced in Access 2003.
I'm not sure how you could achieve this.

[Krandor]

What you need is to google cdosys or cdonts.

Basically, you have the ability to send an entire email automatically (not just set it up in your Outlook).

cdonts was the standard for a very long time and it was simple to use. But Microsoft, in it's infinite wisdom, no longer supports it in it's newest servers. In that case you have to use cdosys which more complicated (not a lot more but enough to aggravate me).

You can do the whole thing in about 10 -15 lines of code, so it shouldn't be a big strech even for a beginner.

I have used these in many of my web sites and the work great.