Sending a hyperlink to the database in Lotus Notes

[mrdod]

I'm working on creating a database for safety audits. Once the auditor performs the audit and submits it an email in Lotus Notes is generated. Is there a way I can include a hyperlink to the database so he/she can open the database from the email?

DoCmd.SendObject , , , "xxx@xxx.com", , , , , "My Documents\Audit_Database.mdb"

Any hints or information would be awesome.

 

[DougP]

yes try this

    Dim msg As String
    msg = "[URL unfurl="true"]http://www.mysite.com/dbname.mdb"[/URL] & vbCrLf
    DoCmd.SendObject acSendNoObject, "", acformattext, "touser@abc.com", , , "Click this link to...", msg, True

the vbCrLf makes the hyperlink show as a hyperlink instead of just text
the True at the end makes the email popup then you have to hit Send this is for testing
you can make it False and will send it out but Outllok when bark about something trying to send behind the scenes. Thank viruses for this. back in Access '97 it would send out without and prompts.

DougP, MCP, A+

 

[mrdod]

Sorry I haven't replied sooner but I've been out of the country. I tried your code and in Lotus Notes it's not showing as a hyperlink it's just text. I copied and pasted the code above and just substituted in my email address. In Lotus Notes whenever I've created a link I needed to create a hot spot. Maybe it isn't possible to do this in Lotus Notes using VBA???