Forum Discussion

NAWAFenezi's avatar
NAWAFenezi
Copper Contributor
Jan 13, 2020

get information

Hello
I work for an organization that has many employees.
I deal daily with their data.
In particular, I deal with the following information:
Job degree, job number, name, national identification number, and department.

All of their information is in my excel file.

My Question:
How to get information about an employee with his job number only.

Rank
Employee number
Name
ID
SECTION
  • Hi Hans
    Thanks for your interest, my dear.
    I mean, for example, if you want to create a letter of thanks to an employee.
    I want to enter the job number in the field of the job number and automatically, the rest of the information such as name, identification number, department and rank come in its exact fields.

    Like the way to search in database programs.

    I hope the idea becomes clear.
  • hansleroy's avatar
    hansleroy
    Iron Contributor

    Hi NAWAFenezi ,

    What do you mean by "get information"?

    I can think of:

    - see that only employee > filter in Excel or in Word, a merge rule

    - see only that information > don't include the othet merge fields

    But you could mean something completely different.

    Kind regards

    Hans

    • NAWAFenezi's avatar
      NAWAFenezi
      Copper Contributor
      Hi Hans
      Thanks for your interest, my dear.
      I mean, for example, if you want to create a letter of thanks to an employee.
      I want to enter the job number in the field of the job number and automatically, the rest of the information such as name, identification number, department and rank come in its exact fields.

      Like the way to search in database programs.

      I hope the idea becomes clear.
      • hansleroy's avatar
        hansleroy
        Iron Contributor

        HiNAWAFenezi 

        No, I don't think that's possible - not in Word. You might want to consider Infopath.

        Kind regards

        Hans

Resources