Help: Access, email, and links

[pholt33]

I have a database (Access 2010) that is used to store and share documents across my small firm. People go into the database, fill out a form and attach whatever document they want available in a centralized location. On submission of a new record an email is generated with some basic info about the document (subject, title, etc) and some terminology stating (paraphrasing), "Hey, coworker, go check out this new publication." What I would like to do is include a link in the email that would allow the coworkers to open the file directly from the email rather than having to get into the database, look up the publication, and then finally open it.

How can I create that link and insert it into the email?

Thanks!

 

[ranman256]

I find that Outlook , if you have the full file path, it creates the hyperlink. But the code below also has the hyperlink method commented out.

Public Function EmailOut(ByVal pvTo, ByVal pvSubj, ByVal pvBody, Optional ByVal pvFile) As Boolean
Dim oApp As Outlook.Application
Dim oMail As Outlook.MailItem
On Error GoTo ErrMail
'===== BE SURE TO ADD OUTLOOK OBJ LIBRARY in VBE,TOOLS, REFERENCES.   ========
Set oApp = CreateObject("Outlook.Application")
Set oMail = oApp.CreateItem(olMailItem)
With oMail
    .To = pvTo
    .Subject = pvSubj
    If Not IsNull(pvBody) Then .Body = pvBody
    'If Not IsMissing(pvFile) Then .Attachments.Add pvFile, olByValue, 1, "attached file"
    
    .Send
End With
EmailOut = True
Set oMail = Nothing
Set oApp = Nothing
Exit Function
ErrMail:
MsgBox Err.Description, vbCritical, Err
Resume Next
Resume
End Function
 
Sub TestEmail()
Const Q = """"
Dim vBody
vBody = "\\serverpath\Support\\generic.pdf"
'vBody = "file:///\\serverpath\Support\\generic.pdf" & Q & ">\\serverpath\Support\\generic.pdf"

call  EmailOut( "bob@Co.com", "Hyperlink", vBody)
End Sub

 

[pholt33]

Thanks, that will be helpful!

Dumb question time...how do I find what the filepath is? When I open any saved file from the database, the file location says its in my local temp folder. That cant be right. The attachment field doesnt seem to give me any insight, either. It seems like this should be a very easy thing to figure out and Im stumped.