Results 1 to 3 of 3
  1. #1
    Marianna_Air is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    56

    Add a hyperlink to email message

    I want to add a hyperlink to an out going email, but I get an error when I try to add it to my code



    Code:
    Private Sub Email_Click()
    On Error GoTo Err_Email_Click
        Me.Refresh
        
        If IsNull(Me![RequestforQuotesID]) Then
            MsgBox "Enter Request for Quotes information before previewing."
        Else
            DoCmd.SendObject acSendReport, "RequestForQuotes_Converted", "PDFFormat(*.pdf)", "", "", "", "Request for Quote", "Vendor, We are looking for vendors that have the ability to accomplish the attached request. Please review and respond as soon as possible with a cost and estimated completion date. Please note: In order to view the attached detail drawings you may need to download Lucent Viewer Enable. This is a free trusted program that can be downloaded at this link http://www.ecedi.com/download123/download.htm Thank you for your time, Marianna Airmotive" 'Send out the E-mail
        End If
          
    Exit_Email_Click:
        Exit Sub
    Err_Email_Click:
        If Err <> 2501 And Err <> 2465 Then
            MsgBox Err.Description
        End If
        Resume Exit_Email_Click
    End Sub

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,972
    What is error message? Looks like just characters in a string, not actually a hyperlink, so don't understand why errors. For clickable hyperlink, night need to use html tags and don't know if SendObject allows for that. There is a TemplateFile argument that might be relevant to this. Review
    http://office.microsoft.com/en-us/ac...001226290.aspx
    http://www.devhut.net/2010/09/03/vba...ok-automation/
    Last edited by June7; 08-22-2012 at 11:15 AM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Marianna_Air is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    56
    I've decided to leave it as a non-hyperlink let people copy and paste it

    Thanks for the help I like that Devhut link

Please reply to this thread with any new information or opinions.

Similar Threads

  1. E-mail hyperlink with pre-defined message
    By healey33 in forum Access
    Replies: 10
    Last Post: 05-31-2012, 08:36 AM
  2. Import Outlook email message
    By crowegreg in forum Import/Export Data
    Replies: 5
    Last Post: 09-27-2011, 11:10 PM
  3. Hyperlink email won't mail-merge
    By alexc333 in forum Access
    Replies: 1
    Last Post: 09-20-2011, 07:17 PM
  4. Changing color in middle of email message
    By tgavin in forum Programming
    Replies: 5
    Last Post: 11-30-2010, 01:19 PM
  5. How to email a hyperlink using VBA
    By Lockrin in forum Access
    Replies: 1
    Last Post: 07-16-2010, 02:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums