I am in excel and have an incident record number that I want to search on in Outlook. I click on the cell in excel that has the record number. I go up to the formula bar and copy (hit control C), then I go to Outlook in the folder I want to search in. I go to the search bar and hit control V or try to right click and hit paste. Either way, nothing appears.
Share
Are you able to Copy/Paste a string from another source, such as a website or an email into the Outlook search bar?
I’m wondering if the format of the string in Excel is screwing up Outlook. If the steps below work, then maybe there is something we can do to the string in the spreadsheet to make it “pastable” into Outlook.
Try the following procedure. Note: Steps 2 – 4 may not be necessary…I included them just to make sure that any formatting that came along with the Copy/Paste from Excel is no longer attached to the string. Belt, suspenders and a staple gun. 😉
1 – Copy your string from Excel into Word, using the Keep Text Only option.
2 – Save and Close the Word document
3 – Remove the string from your clipboard by doing a Copy/Paste of something else, something not related to your spreadsheet.
4 – Open the Word document.
5 – Copy the string from Word and try to paste it into the Outlook search bar.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.