@Name

Hi,

I have a formula that looks up a members from a group in the address book. I then abbreviate the name by doing the following:

@Name([Abbreviate];departmentmngrs).

Some of the names it shows Name/Unit/Company and other names it shows Name/Unit/Company@domain

How can I get rid of the odd @domain bit?

Another query. I have a form where a user can be in the authors field and readers field. Is this possible? I am getting an error when that user wants to edit the document - “Cannot Execute the specified command”.

Subject: @Name

  1. Try:

@Name([Abbreviate];@left(departmentmngrs + “@”;“@”));

  1. Yes a user can appear in Both Authors and Readers fields without problems, they both control a different facet of the document’s access.

If the user can’t edit the document, and they have Author access, check the values being stored in the Authors field. Common mistakes are to not make it multi-value (but add multiple names), or to store the name in a format other than canonicalised.

HTH - Rufus.