file path changes when emailed

[jane]

For the footers on my excel documents, I am requried to include the complete
file path.

When I email the docs to another user, the file path changes. This creates
a problem when I email the docs to the copy center to have them printed. The
temp file location appears and not the original location that our users need
to see at the bottom of the docs.

How can I lock the file location so it doesn't change when emailed?

thanks in advance, jane

 

[Dave Peterson]

Type in what you want.

You don't want to use something that points to the current location.