Got an easy one for you. On the table design view, how do you make one of
the fields a link that holds an email address so when you click on it, it
opens outlook and puts the email address in the 'To' in outlook email. I
know it has to be simple. They have a simple option for websites, I just
can't figure out how to make it work with email.

Curt




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Hi, Curt

I don't know how other people solve this, but I make those fields hyperlinks
then enter the email addresses like this: mailto:johnsmith (AT) hisdomain (DOT) com.
That will pull up your mail client.

ok, and every record has a different email address. Is there a string or
something to put in place of your example of johnsmith (AT) hisdomain (DOT) com that
will use whatever is in that field? Example :
mailto:speicalstring_of_current_recordfield




"LWD" <lucdix-NOSPAM (AT) NOSPAM-jam (DOT) rr.com> wrote




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Hi, Curt

Perhaps we misunderstand each other, but once again, here's the way I do it.

When I add fields in table design view, I make them text, or currency, or
memo, etc. but I make an email field a hyperlink:
e.g....

LastName text
FirstName text
Address text
City text
State text
email hyperlink (http:// is the default)

But here's the problem with data input as far as hyperlinks:

if I input a regular email address - let's say 'johnsmith (AT) yahoo (DOT) com' and
then click on it, Access thinks I want to go to www.yahoo.com, not send an
email. In other words, it assumes that 'hyperlink' means
http://www.yahoo.com - when what I want is a 'mailto:' link which will open
up Outlook or Outlook Express or Eudora, etc.

So what has worked for me has been to create the field as a hyperlink in
design view, as I mentioned above, but then, when I'm *inputting* John
Smith's email address to put it in in this form:
mailto:johnsmith (AT) yahoo (DOT) com.

Does that help?

There may well be a more sophisticated way to do this, a way to make the
default hyperlink prefix be 'mailto:' instead of 'http://' - but I don't
personally know of any other method. I can tell you that my way works.

L.

I just use a text field and then use a button to call ..

eg. fields on a form to construct an email

DoCmd.SendObject acSendNoObject,,, Me![txtTo], Me![CC], Me![BCC],
Me![Subject], Me![MsgText], True

(The True on the end will open the email up to edit, otherwise it will send)

As you can see, you can also set some other variables like the subject and
message text.
--
Bradley
Software Developer www.hrsystems.com.au
A Christian Response www.pastornet.net.au/reponse

"LWD" <lucdix-NOSPAM (AT) NOSPAM-jam (DOT) rr.com> wrote