Home

excel outlook querry

%3CLINGO-SUB%20id%3D%22lingo-sub-1137061%22%20slang%3D%22en-US%22%3Eexcel%20outlook%20querry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137061%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wondering%20if%20it%20is%20at%20all%20possible%20to%20link%20a%20specific%20email%20in%20outlook%20to%20a%20data%20field%20%2F%20cell%20in%20excel.%3C%2FP%3E%3CP%3ETrying%20to%20build%20a%20spreadsheet%20with%20info%20on%20it%20and%20I%20want%20to%20be%20able%20to%20have%20an%20easy%20way%20to%20refer%20%2F%20link%20back%20to%20the%20email%20that%20provided%20the%20info%20in%20the%20first%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1137061%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1137292%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20outlook%20querry%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137292%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F537134%22%20target%3D%22_blank%22%3E%40GodfreyB%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20use%20Power%20Query.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EData%20menu%2C%20Get%20Data%2C%20from%20Other%20Sources%20%2C%20MS%20Exchange%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20Power%20Query%20editor%20you%20can%20filter%20to%20remove%20the%20messages%20you%20don't%20need.%26nbsp%3B%20You%20can%20remove%20non-essential%20columns%2C%20too.%26nbsp%3B%20Depending%20on%20the%20fields%20needed%2C%20you%20may%20have%20expand%20a%20few%20structured%20columns.%26nbsp%3B%20Load%20to%20sheet%20when%20done.%3C%2FP%3E%3C%2FLINGO-BODY%3E
GodfreyB
Occasional Visitor

I am wondering if it is at all possible to link a specific email in outlook to a data field / cell in excel.

Trying to build a spreadsheet with info on it and I want to be able to have an easy way to refer / link back to the email that provided the info in the first place.

1 Reply
Highlighted

@GodfreyB 

Yes, use Power Query.

 

Data menu, Get Data, from Other Sources , MS Exchange

 

In the Power Query editor you can filter to remove the messages you don't need.  You can remove non-essential columns, too.  Depending on the fields needed, you may have expand a few structured columns.  Load to sheet when done.

Related Conversations
Need Help Creating This Formula
James Reuland in Excel on
0 Replies
Excel Find and replace
Brickson_Dimas in Excel on
0 Replies
Excel on iPad
Mattlewis in Excel on
2 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies