If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Access > Putting hyperlink in a generated e-mail that will open a form in access

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Location: London
Posts: 326
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
Reply With Quote
  #4 (permalink)  
Old
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 12,300
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.
__________________
Is taking part in the 'Distinguished Gentlemans' ride. Being neither distinguished nor a gentleman, but I am keen to raise funds for Prostrate Cancer research. At present I'm threatening to ride a Norton 961 wearing a kilt. If you would like to contribute to Prostrate Cancer research then please consider donating via this page:-
http://www.gentlemansride.com/rider/healdem
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Oct 2003
Location: London
Posts: 326
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On