Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Access 2000 Email field format

Discussion in 'Information Technology' started by FrankSpokane, Jul 28, 2006.

  1. FrankSpokane

    FrankSpokane
    Expand Collapse
    Guest

    I have an .mdb of names, addresses and email addresses that I want to be able
    to create an online web directory.

    I have set the format of the email field as a hyperlink, but when I create a
    report and export it - the email address shows incorrectly - as a website
    link and not as a email address.

    It shows up as http://yourname@yourdomain.com
    and I want it to be mailto:yourname@yourdomain.com

    How/where do I do this?

    Thanks

    Frank in Spokane
     
  2. Loading...


  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    There is a difference between a hyperlink and an e mail address.

    To use the click to send an e mail (opens outlook on most d bases) you need
    to store the data as a mailto.

    mailto:thename@thecompnay.com

    Hope this helps

    --
    Wayne




    "FrankSpokane" wrote:

    > I have an .mdb of names, addresses and email addresses that I want to be able
    > to create an online web directory.
    >
    > I have set the format of the email field as a hyperlink, but when I create a
    > report and export it - the email address shows incorrectly - as a website
    > link and not as a email address.
    >
    > It shows up as http://yourname@yourdomain.com
    > and I want it to be mailto:yourname@yourdomain.com
    >
    > How/where do I do this?
    >
    > Thanks
    >
    > Frank in Spokane
    >
     
  4. FrankSpokane

    FrankSpokane
    Expand Collapse
    Guest

    RE: Access 2003 Email field format

    Do you mean that when I enter any new email addy I have to add the mailto: in
    front of the regular addy?

    "Wayne-in-Manchester" wrote:

    > There is a difference between a hyperlink and an e mail address.
    >
    > To use the click to send an e mail (opens outlook on most d bases) you need
    > to store the data as a mailto.
    >
    > mailto:thename@thecompnay.com
    >
    > Hope this helps
    >
    > --
    > Wayne
    >
    >
    >
    >
    > "FrankSpokane" wrote:
    >
    > > I have an .mdb of names, addresses and email addresses that I want to be able
    > > to create an online web directory.
    > >
    > > I have set the format of the email field as a hyperlink, but when I create a
    > > report and export it - the email address shows incorrectly - as a website
    > > link and not as a email address.
    > >
    > > It shows up as http://yourname@yourdomain.com
    > > and I want it to be mailto:yourname@yourdomain.com
    > >
    > > How/where do I do this?
    > >
    > > Thanks
    > >
    > > Frank in Spokane
    > >
     
  5. FrankSpokane

    FrankSpokane
    Expand Collapse
    Guest

    I changed one record - added the mailto: to the beginning of an existing
    email address in the email field, and the report generated worked correctly,
    in that someone can click on the email address in the online report and send
    the person email.
    Would you have a suggestion as to how I can change the other 3000+ records I
    have in my .mdb now?
    Logic would be in the email field - add mailto: to the beginning of the
    existing email addy

    Thanks

    "Wayne-in-Manchester" wrote:

    > There is a difference between a hyperlink and an e mail address.
    >
    > To use the click to send an e mail (opens outlook on most d bases) you need
    > to store the data as a mailto.
    >
    > mailto:thename@thecompnay.com
    >
    > Hope this helps
    >
    > --
    > Wayne
    >
    >
    >
    >
    > "FrankSpokane" wrote:
    >
    > > I have an .mdb of names, addresses and email addresses that I want to be able
    > > to create an online web directory.
    > >
    > > I have set the format of the email field as a hyperlink, but when I create a
    > > report and export it - the email address shows incorrectly - as a website
    > > link and not as a email address.
    > >
    > > It shows up as http://yourname@yourdomain.com
    > > and I want it to be mailto:yourname@yourdomain.com
    > >
    > > How/where do I do this?
    > >
    > > Thanks
    > >
    > > Frank in Spokane
    > >
     
  6. rogereverest

    rogereverest
    Expand Collapse
    Guest

    Yes - you can do it in VBA or by an update query. In the query "update to"
    field specify an expression "Mailto: " & emailfieldname.

    "FrankSpokane" wrote:

    > I changed one record - added the mailto: to the beginning of an existing
    > email address in the email field, and the report generated worked correctly,
    > in that someone can click on the email address in the online report and send
    > the person email.
    > Would you have a suggestion as to how I can change the other 3000+ records I
    > have in my .mdb now?
    > Logic would be in the email field - add mailto: to the beginning of the
    > existing email addy
    >
    > Thanks
    >
    > "Wayne-in-Manchester" wrote:
    >
    > > There is a difference between a hyperlink and an e mail address.
    > >
    > > To use the click to send an e mail (opens outlook on most d bases) you need
    > > to store the data as a mailto.
    > >
    > > mailto:thename@thecompnay.com
    > >
    > > Hope this helps
    > >
    > > --
    > > Wayne
    > >
    > >
    > >
    > >
    > > "FrankSpokane" wrote:
    > >
    > > > I have an .mdb of names, addresses and email addresses that I want to be able
    > > > to create an online web directory.
    > > >
    > > > I have set the format of the email field as a hyperlink, but when I create a
    > > > report and export it - the email address shows incorrectly - as a website
    > > > link and not as a email address.
    > > >
    > > > It shows up as http://yourname@yourdomain.com
    > > > and I want it to be mailto:yourname@yourdomain.com
    > > >
    > > > How/where do I do this?
    > > >
    > > > Thanks
    > > >
    > > > Frank in Spokane
    > > >
     

Share This Page