title: How to get the Email Address from names.nsf domino directory - Lotus Notes
body: <p>I have an employee info form that has fields Employee No, Employee Name &amp; Employee Email Address. When registered a new employee info, I am not able to get Email address ( from the Domino Directory names.nsf), the employee name from the form has to match with the name in directory and bring the mail address.<br>
  Please help me as am new to Lotus notes :(
  I tried this formula...for Email address field...  </p>
  
  <pre><code>server := @Name([CN]; @Subset(@DbName; 1));
  err := "No email address found, plz chk Domino Directory";
  @If(EmpName != ""; @DbLookup("":"NoCache";server:"names.nsf";"People";Name;4); Email);
  @If(@IsError(err)=err)
  </code></pre>
  
  <p>But this is not working, I get only the error but not the email address. Plz help me :(
  I then tried with DbColumn... itz populating all the email addresses in the email field.<br>
  My requirement is bring the email address of the name matching with the employee name registerd from the domino directory, if email addr not exist, display error.</p>