|How did the incident number get into the spreadsheet - Manually entered? Copied from another source? Downloaded from an external source? |
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.