Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Hyperlinks/Email addresses (97)

    I have a table with a hyperlink field with the client's email address. Because my client is using Lotus Notes and not Outlook (ugh), I have to prefix each address with mailto: if I want the hyperlink to open Lotus Notes. Currently I am storing the mailto: as part of the field. I want to have a query that lists name and email address without the mailto: listed, but with a comma after each name. I guess they want to export this to their To: field in Lotus Notes.

    Any suggestions.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks/Email addresses (97)

    If mailto: is always at the beginning of the field you can use the mid function in an expression in a calculated field in a query to isolate the name. Then just concatenate a comma. Something like

    Mail To: Mid([hlinkfield],8) & ","


    Make it 9 if there is a space between mailto: and the name.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks/Email addresses (97)

    when I try this, I get the # sign between the address and the , . For example:

    EmailAddress: Mid([email],9)& "," = peachent@aol.com#,

    any hints?

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Hyperlinks/Email addresses (97)

    I would change it to :

    EmailAddress: Left([email],9) & ","

    Where does = peachent@aol.com come from?

    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks/Email addresses (97)

    Sorry for the confusion - I was typing in.....
    EmailAddress: Mid([email],9)& "," and for the record that read mailtoeachent@aol.com the result was peachent@aol.com#,

    I don't want the # sign!!!

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Hyperlinks/Email addresses (97)

    Can you verify that the record read mailtoeachent@aol.com ?
    What is the length of the field where the email address is? Is it 23 ( I think I counted right) or 24?
    Pat

  7. #7
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Hyperlinks/Email addresses (97)

    I thought I would do a little further investigation, and I have found that when you view the table's HyperLink field you don't see the leading (yes there is a leading #) or trailing # sign. I read a HyperLink field from the table into a variant field and saw these 2 characters.
    Your expression should probably be :
    Mid([email],9,Len([email])-10)
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Hyperlinks/Email addresses (97)

    How are you going with this problem, just interested.
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  9. #9
    2 Star Lounger
    Join Date
    Jan 2001
    Posts
    159
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Hyperlinks/Email addresses (97)

    the last suggestion worked, except I had to make it -9 instead of -10.
    What does the -10 at the end of the string mean?
    Thanks for help!

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Hyperlinks/Email addresses (97)

    The mid instruction is
    Mid([Email],start,length)
    Where:
    start is where you want to begin taking data
    length is how long a string you need to take

    Suppose you string looked like
    #mailto:thornp.iprimus.com.au#

    The start is 9 which is the t of thornp
    The length is 30 characters but we only want 30-9 characters, the 9 characters are the #mailto: and the trailing #.

    Hope this makes it clear, hmmn...
    Pat <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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