Automatically mapping Windows network addresses to Mac

Unless they use a full network path, there is nothing you can do.

Z:/ can reference any network path. It is essentially a shortcut that is only defined on that person's computer. It can be different for every user.

If you can teach your Windows associates to use full network paths, then you may be be able to resolve it, possible automatically.

I'm not aware of any extensions that will help you with this. As I said, Unix does not use drive letters at all.

Connecting to a network share is simple, but you can't give it a drive letter and links sent to you that use drive letters won't work.

You have to use the full UNC name. e.g. \\servername\sharename\foldername\file.ext

Using mapped drive letters is largely seen as an archaic unnecessary practice among sysadmins these days. The only thing that keeps the practice alive is users, especially those in upper management, can't wrap their heads around the concept.

No. macOS is based on BSD Unix. Unix does not use drive letters. You will have to navigate to the UNC name manually for the share.

You have no idea what share Z:\ points to on the network, so there is no way to resolve it. Each user can set Z:\ to point to anything they want.

They will likely not know what that points to, either.

So, is Z drive mapped to Z:\xyz\abc\ or Z:\xyz\

That would work if they are sending you the full path after the Z:/, but they are not.

The full network path of your example, Z:\xyz\abc\file.xls, could be //server/groups/org/department/xyz/abc/file.xls.

Nothing can determine that Z:\ = //server/groups/org/department/.

If you know that everyone maps Z to //server/groups/org/department, you could use any tool such as the one you found to prepend the stuff after Z with //server/groups/org/department/. If there isn't a standard location, then you have no idea what the full path is.