email format

Discussion in 'Access Table Design' started by CJ, May 2, 2004.

  1. CJ

    CJ Guest

    How you you set a field to "email format"?
     
    CJ, May 2, 2004
    #1
    1. Advertisements

  2. There is no such format as "email" format. There is a Hyperlink Data Type
    available that takes an internet domain (www.somesite.com) and formats it so
    that a click takes the user to the indicated web site. However, these are
    annoying to edit to make them "mailto's" instead of "http's".

    If you are looking for a way that a user can click on some data in a form
    and have it open your MAPI-compliant email client, here is a suggestion:

    Presuming that your form has a text box control named: EMail: You can use
    the control's properties to make the ForeColor blue and Underscored (so that
    it looks "special and kind of like a hyperlink"). Then insert the
    following code behind the Double Click event of that text box.

    Dim strEmail as String

    strEmail = "mailto:" & Me.
    Application.FollowHyperlink Address:=strEmail

    Substitute your actual field name for EMail in the above code.

    In the event that this is the first time that you will have to code an
    event, here is how to do it:

    In your form's design view, right-click on the text box containing the email
    address, then select Properties from the pop-up menu. In the properties
    sheet for that text box, find the DblClick event and click anywhere on that
    line. You will see a downward pointing arrow at the right edge of the line.
    Click it and select Event Procedure. Then, look for the small button to the
    right of the downward pointing arrow which contains an ellipsis (three dots
    ....). Click this button to open the code window for the Dbl Click event.

    When the code window is first opened, it will look like this:

    Private Sub Email_DblClick(Cancel As Integer)

    End Sub

    You will want to insert the following lines after the "Private Sub
    Email_DblClick(Cancel as Integer)" line

    Dim strEmail as String

    strEmail = "mailto:" & Me.[EMail]
    Application.FollowHyperlink Address:=strEmail

    Save and close the code window; save your form and return it to form view.
    Double click on your text box email value and your MAP-compliant email
    client should open with the email address in the TO: line.



    --

    Cheryl Fischer, MVP Microsoft Access
    Law/Sys Associates, Houston, TX


    "CJ" <> wrote in message
    news:...[color=blue]
    > How you you set a field to "email format"?[/color]
     
    Cheryl Fischer, May 2, 2004
    #2
    1. Advertisements

  3. CJ

    alex Guest

    I am frustrated by gmail format. It's so messy, it's hard to find out where/what the previous messages are when I am replying. What gmail cannot display as other email??




    On Monday, May 3, 2004 12:09:42 AM UTC+10, Cheryl Fischer wrote:
    > There is no such format as "email" format. There is a Hyperlink Data Type
    > available that takes an internet domain (www.somesite.com) and formats it so
    > that a click takes the user to the indicated web site. However, these are
    > annoying to edit to make them "mailto's" instead of "http's".
    >
    > If you are looking for a way that a user can click on some data in a form
    > and have it open your MAPI-compliant email client, here is a suggestion:
    >
    > Presuming that your form has a text box control named: EMail: You can use
    > the control's properties to make the ForeColor blue and Underscored (so that
    > it looks "special and kind of like a hyperlink"). Then insert the
    > following code behind the Double Click event of that text box.
    >
    > Dim strEmail as String
    >
    > strEmail = "mailto:" & Me.
    > Application.FollowHyperlink Address:=strEmail
    >
    > Substitute your actual field name for EMail in the above code.
    >
    > In the event that this is the first time that you will have to code an
    > event, here is how to do it:
    >
    > In your form's design view, right-click on the text box containing the email
    > address, then select Properties from the pop-up menu. In the properties
    > sheet for that text box, find the DblClick event and click anywhere on that
    > line. You will see a downward pointing arrow at the right edge of the line.
    > Click it and select Event Procedure. Then, look for the small button to the
    > right of the downward pointing arrow which contains an ellipsis (three dots
    > ...). Click this button to open the code window for the Dbl Click event.
    >
    > When the code window is first opened, it will look like this:
    >
    > Private Sub Email_DblClick(Cancel As Integer)
    >
    > End Sub
    >
    > You will want to insert the following lines after the "Private Sub
    > Email_DblClick(Cancel as Integer)" line
    >
    > Dim strEmail as String
    >
    > strEmail = "mailto:" & Me.[EMail]
    > Application.FollowHyperlink Address:=strEmail
    >
    > Save and close the code window; save your form and return it to form view.
    > Double click on your text box email value and your MAP-compliant email
    > client should open with the email address in the TO: line.
    >
    >
    >
    > --
    >
    > Cheryl Fischer, MVP Microsoft Access
    > Law/Sys Associates, Houston, TX
    >
    >
    > "CJ" <> wrote in message
    > news:...[color=green]
    > > How you you set a field to "email format"?[/color][/color]
     
    alex, Mar 31, 2014
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Chaster

    Change Format of Phone Field

    Chaster, Jul 23, 2003, in forum: Access Table Design
    Replies:
    0
    Views:
    162
    Chaster
    Jul 23, 2003
  2. tektrader78

    Rearranging Data Format of entries in Access

    tektrader78, Aug 4, 2003, in forum: Access Table Design
    Replies:
    1
    Views:
    79
  3. JG316

    Table Design Field: EMail Address Format/Mask

    JG316, Jun 3, 2004, in forum: Access Table Design
    Replies:
    1
    Views:
    88
    Allen Browne
    Jun 3, 2004
  4. Charles Phillips

    Email format

    Charles Phillips, Sep 29, 2004, in forum: Access Table Design
    Replies:
    0
    Views:
    62
    Charles Phillips
    Sep 29, 2004
  5. M. Hayden
    Replies:
    0
    Views:
    73
    M. Hayden
    May 3, 2005
  6. AccessHelp
    Replies:
    1
    Views:
    253
    Douglas J. Steele
    Jan 20, 2006
  7. sippyuconn

    Email and Distribution Lists to send Reports thru email

    sippyuconn, Apr 19, 2007, in forum: Access Table Design
    Replies:
    1
    Views:
    71
    Peter Yang [MSFT]
    Apr 20, 2007
  8. Chris Lines
    Replies:
    2
    Views:
    144
    Chris Lines
    Sep 21, 2009
Loading...