Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Aug 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    e-mail address in forms

    I have a form in Access 2000 where I can view customer data. One of the fields is a text box where I insert a webpage URL. I have set up the text box property Hyperlink = Yes so that by clicking on the URL, IE opens up and takes me directly to the webpage.

    I have a second text box where I insert the e-mail address. However if I activate the Hyperlink property, the address turns into an underlined blue, but nothing happens when I click on it. How can I set it up so that by clicking on it, a ready-addressed message opens in Outlook?

    Or am I asking too much? <img src=/S/angel.gif border=0 alt=angel width=15 height=21>

    Daniele

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: e-mail address in forms

    try looking at SendObject
    in help it should do what you want

  3. #3
    New Lounger
    Join Date
    Aug 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: e-mail address in forms

    Jerry,
    I had a look at SendObject, but it doesn't seem to do what I want. <img src=/S/sad.gif border=0 alt=sad width=15 height=15> I understand it is used for sending entire forms or reports by e-mail.

    What I have is a form with name, address, telephone. etc. One field has the webpage URL, and this field has the hyperlink property enabled. When I click on this field, IE opens and gets me the webpage.

    I was wondering if it was possible do the same trick with the e-mail field - I would like Outlook to open with a blank e-mail message weith the e-mail address filled in.

    Any ideas?

    Daniele

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: e-mail address in forms

    Check out this <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=acc&Number=35310&page=&view =&sb=&vc=1>post</A> (particularly the reply by Tim K.)

  5. #5
    New Lounger
    Join Date
    Aug 2004
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: e-mail address in forms

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>That's it! Many thanks for pointing me the way!

    Daniele

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •