hyperlink to database on desktop in email

[motleyjew]

I have an access 2003 database that has a approve/reject email procedure. If someone approves a job, they click the approve button and an email in outlook will pop up with a set message. I would like to know if it is possible to put a link in the email that will send the person to the copy of their frontend located on their desktop. The main issue is that everyone has a differant username so the link will change based on the user login id. Here is an example of the link i have tried.

"file:///C:\Documents%20and%20Settings\" & fGetUserName & "\Desktop\MyDatabase.mdb"

fGetUserName = VBA.Environ("UserName")

The problem I had with this code is that it captures MY login id instead of the person opening the email. So if I were to click on the link it would work, but if I send it to somebody, it would still show my login id thus making the link usless. Is anyone aware of a way to capture the current users name in the link.
Thanks
Gregg

 

[pbaldy]

Can you capture the email address you're sending the link to and derive the login from that?

 

[motleyjew]

Paul,

Yes I can! This is a great solution. Thank you for solving my problem. I do have a email table that has the username in there so I can have it entered in this way. Thank you again for your help. Let me also let you know that your previous posts have helped me greatly in the past. I will make sure to give you positive feedback in the recommendations.

Greatly appreciated
Gregg

 

[pbaldy]

Thanks Gregg, it's nice to know I've helped you out.