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

Email from a form

P: 10
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
Aug 12 '08 #1
Share this Question
Share on Google+
6 Replies


100+
P: 167
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.
Aug 12 '08 #2

P: 10
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
Aug 12 '08 #3

P: 10
Sorry correction in is office 2002
Aug 12 '08 #4

NeoPa
Expert Mod 15k+
P: 31,186
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 :(
Aug 12 '08 #5

100+
P: 167
Unfortunatelly Smart Tags are introduced in Access 2003.
I'm not sure how you could achieve this.
Aug 13 '08 #6

P: 50
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.
Aug 13 '08 #7

Post your reply

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