SOLVED

is there any way to auto populate user dept, name etc with email address into Excel from Outlook?

%3CLINGO-SUB%20id%3D%22lingo-sub-2391574%22%20slang%3D%22en-US%22%3Eis%20there%20any%20way%20to%20auto%20populate%20user%20dept%2C%20name%20etc%20with%20email%20address%20into%20Excel%20from%20Outlook%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2391574%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20like%20to%20check%20if%20there's%20any%20way%20to%20auto%20populate%20using%20email%20address%20to%20pick%20up%20the%20user%20name%2C%20department%2C%20contact%20etc%20from%20Outlook%20addresses%20book%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20only%20have%20the%20email%20addresses..%20need%20to%20search%20one%20by%20one%20in%20outlook%26nbsp%3B%20to%20find..%20is%20there%20a%20easier%20way%3F%3C%2FP%3E%3CP%3EEXCEL%20-%200365%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2391574%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2401420%22%20slang%3D%22en-US%22%3ERe%3A%20is%20there%20any%20way%20to%20auto%20populate%20user%20dept%2C%20name%20etc%20with%20email%20address%20into%20Excel%20from%20Outlook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2401420%22%20slang%3D%22en-US%22%3EPerhaps%20this%20helps%3F%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fanalyzing-your-microsoft-exchange-account-data-with-power-query%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fanalyzing-your-microsoft-exchange-account-data-with-power-query%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Contributor

hi

 

I like to check if there's any way to auto populate using email address to pick up the user name, department, contact etc from Outlook addresses book?

 

I only have the email addresses.. need to search one by one in outlook  to find.. is there a easier way?

EXCEL - 0365

 

Thanks

 

Regards

2 Replies