Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146

    Unanswered: Send email via access (outlook 03 issues)

    This code works on my computer but when I try running it on my other pc it inserts the hyperlink as a string of text and not an actual hyperlink.

    Any ideas?

    Code:
            Dim oMailApp As Outlook.Application
            Dim oMail As Outlook.MailItem
    
    
        Set oMailApp = CreateObject("Outlook.Application")
        Set oMail = oMailApp.CreateItem(olMailItem)
        With oMail
            .To = "Blocker"
            .Subject = "Blocker Reports for " & Date
            .Body = vbCrLf & vbCrLf & "\\Aus_file\users\USERS\GROUPS\CLAIMS\Reports_from_Data_Analyst\Blocker\Current\"
            .Display
            .Send
        End With

  2. #2
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    we found it.

    you have to turn Word off as your email editor.

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Quote Originally Posted by michelin man
    you have to turn Word off as your email editor.
    A wise move regardless.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    NEVER EVER EVER buy anything from Chrysler New Yorker or anything with the term "lincoln" in it. It is absolute crap. Think about it... they need to resort to forum spamming to try to hoc their crap. Pass it on, spam everywhere how much crap they are.

    lol
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    In anticipation of your next post - my pleasure
    Testimonial:
    pootle flump
    ur codings are working excelent.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well in continuance with reverse posting,...

    Thanks

    Forum spammers are a scourge!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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