Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sending link to Outlook (Access 97 SP2)

    Outgoing mail format = HTML.

    Using Outlook XP, Access 97 on a Win2k machine
    (also tested on an XP machine w/ Outlook XP, with this database as a runtime install):

    I am creating the body of the email message by accumulating items into a text variable.

    This has the same basic format as orders/invoice.

    Basically, I get several items per person.
    Each item has two pieces -- the topic title, and the link to that topic.

    My Link is a link field in the table, and I double-click on it, and go to the proper place (working link).

    I loop to get the two pieces of each item into one line:
    Do While current_user = loop_user
    listglom = listglom & Chr$(13) & Chr$(10) & myset!Topic & Chr(9) & HyperlinkPart(myset!TopicDoc, acAddress)
    -- etc -- (er, I do know vbCRLF)
    Loop 'while current_user etc

    ' No longer current_user, fall out & send
    Set itm = appOutlook.CreateItem(olMailItem)
    With itm
    .To = ToEdress
    .Subject = subjline
    .Body = introWords & listglom & sigblock
    .BodyFormat = olFormatHTML
    .Save
    End With
    Set itm = Nothing

    - The link does not highlight or underline as a link, which I was afraid would happen since it was a text string, although I have HTML formats designated.
    - _but_ if I just go to the end of the item line, and hit the space bar, the item becomes underlined and highlighted -- _but_ it still fails to act as a link.

    Anyone have any clues?

    thx
    Pat W.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sending link to Outlook (Access 97 SP2)

    I don't know how to change the text to a hyperlink automatically. But the text that became underlined and blue after you typed a space *will* be a link for the person who receives the e-mail. You can test this by sending it to yourself.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Salem, Oregon, USA
    Posts
    219
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sending link to Outlook (Access 97 SP2)

    Oh (<embarrassed grin>) I thought I had already tested that out!
    That part _does_ work !!! Thank you!
    I realize that there is just a space at the end of the line, and I don't want to strip the line feed if it's that, and I did (once earlier, and just now, again) apply the trim() function to the link portion.
    But thanks very much ! for enlightening me on the one thing <g>, that in itself will mean I can send it to the user, it will save more time than not, even if it's in a not-quite-perfect state, yet.
    thx
    Pat

Posting Permissions

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