How To Find The Email Ids If Given A List Of Users (say 100)?

1.	How To Find The Email Ids If Given A List Of Users (say 100)?
Answer» The list of email ids for given USERS can be GENERATED by performing the below steps: Execute the t-code SE16 Enter the table name as USR21. UPLOAD the list of users using multiple selection option and execute. This will give us the list of users and their respective person numbers Extract this data to excel SHEET Now, go back to SE16 and enter table name ADR6 Upload the list of person number extracted from table USR21 and execute Now, table ADR6 will give us the list of person numbers and their email ids. Download the list in excel and perform V-look up in excel to map the email ids of users with their SAP IDs The list of email ids for given users can be generated by performing the below steps:

Answer»

The list of email ids for given USERS can be GENERATED by performing the below steps:

Execute the t-code SE16
Enter the table name as USR21.
UPLOAD the list of users using multiple selection option and execute. This will give us the list of users and their respective person numbers
Extract this data to excel SHEET
Now, go back to SE16 and enter table name ADR6
Upload the list of person number extracted from table USR21 and execute
Now, table ADR6 will give us the list of person numbers and their email ids.
Download the list in excel and perform V-look up in excel to map the email ids of users with their SAP IDs

The list of email ids for given users can be generated by performing the below steps:

Discussion