Private Sub Command0_Click()



Dim MiOutlook As Outlook.Application
Dim MiCorreo As Outlook.MailItem

Dim NombreFichero As String
Dim NombreFicheroConRuta As String


Set MiOutlook = New Outlook.Application

Set MiCorreo = MiOutlook.CreateItem(olMailItem)

With MiCorreo

.To = "alanfong@yahoo.com"

.Subject = "Test"

.Body = "Open database"

.Send

End With

Set MiCorreo = Nothing
Set MiOutlook = Nothing
End Sub


Send mail via outlook from MS Access:
Suppose the database is in the sharing drive, everyone can access it. I want to create a link when I send mail, which the link can open the database.
However, the link doesn't work.

Does anybody know that? Thanks.