Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2011
    Location
    Portland, Oregon
    Posts
    2

    Putting hyperlink in a generated e-mail that will open a form in access

    Hello - I have a form for sales people that contains a field where a follow-up call date is entered. When this date is entered it generates an e-mail and sends it to the sales person reminding them to call the client. I would like to create a hyperlink to place in the email that will open the Client Information form and display a specific record, based on the ProjectID. Is this possible? What I want is to include in the content of the e-mail a hyperlink specific to the ProjectID that will allow the sales person to click on it and it will open the database and take them to the specific record. Let me also include the coding that sends the e-mail message to outlook - can the hyperlink and coding associated with it be put into the already existing coding? If so please be specific as to where I should put it:

    Private Sub FUDateContacted_AfterUpdate()

    Dim appOutLook As Object
    Dim MailOutLook As Object

    Set appOutLook = CreateObject("Outlook.Application")
    Set MailOutLook = appOutLook.CreateItem(olMailItem)

    With MailOutLook
    .To = Me.EmailRecipient 'get the recipient from the form
    .Subject = "Project ID:" & Me.ID & ", Street Ref: " & Me.ClientStreet 'get the street and ID from the form
    .body = "This is a reminder that you need to make a follow up call to the address in the Subject line today." (Can the hyperlink to the ProjectID be put in this content?)
    .DeferredDeliveryTime = Me.FUDateContacted 'get the date from the form

    .Send
    End With

    Set appOutLook = Nothing
    Set MailOutLook = Nothing

    End Sub

    Again - thanks tons for any help!

    Laura

  2. #2
    Join Date
    Apr 2011
    Location
    Portland, Oregon
    Posts
    2

    Hyperlink

    Why won't anyone help me? If this is not possible will someone please tell me so I'll quit posting it? Can anyone point me in the right direction?

    Laura

  3. #3
    Join Date
    Oct 2003
    Location
    London
    Posts
    327

    Question

    Hey,

    Did you get a solution?

    I'm used to creating emails another way, but this might work for you;

    Code:
    Private Sub Cmd_SendIntial_Click()
    
    Dim MsgSubject
    Dim MsgBodyLink
    Dim MsgBody
    Dim MsgSignatureLink
    Dim MsgSignature
    
    ' Create the Subject
    
    MsgSubject = "Project ID:" & Me.ID & ", Street Ref: " & Me.ClientStreet
    
    ' Create the Body
    
        MsgBody = vbCrLf _
        & "This is a reminder that you need to make a follow up call to the address in the Subject line today." _
        & vbCrLf _
        & vbCrLf _
        & HyperlinkPart(Me.ProjectID) _
        & vbCrLf _
        & vbCrLf
    
    ' Create the signature
        MsgSignature = vbCrLf _
        & "Regards, " _
        & vbCrLf _
        & vbCrLf _
        & "Christyxo" _
        & vbCrLf _
        & vbCrLf _
        & HyperlinkPart("http://www.dbforums.com/members/christyxo.html")
    
    ' Create the full message
        MsgBody = MsgBody & MsgSignature
    
    ' Send the message
        DoCmd.SendObject , , , Me.EmailRecipient, , , MsgSubject, MsgBody, True
    ' Note, change the final arguement to FALSE to send the email automatically.
    
    End Sub

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    12,525
    you shoudl be able to do thgis
    however I suspect the level of detail knowledge to do this may make it tricky to implemnent

    to open a form means that you need to open Access from the email. that means.. easy enough to do use the command line switches to open the specific access application, run a macro or vb procedure usi8ng a supplied parameter.

    ..however unless Access is in the path on the target computer you will almost certainly need to supply the path to the executable for each and every pc that is the recipinet for the email

    persoanlly I think you would be far better off reprising the information in the email, rahter than expecting the email recipient to open a link to Access.
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Oct 2003
    Location
    London
    Posts
    327
    healdem, totally misread the question! I only read about the hyperlink park, not that it needed linking to a specific record!

    Thanks for clearing up my mistake.

Posting Permissions

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