Solved I can't copy & paste text from Excel into Outlook search

July 17, 2014 at 07:01:34
Specs: Windows 7
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.

See More: I cant copy & paste text from Excel into Outlook search

Report •


#1
July 17, 2014 at 13:04:06
While you are waiting for further advice, with the same reference please confirm that you can copy it into Notepad or Word using Control V.

Always pop back and let us know the outcome - thanks


Report •

#2
July 17, 2014 at 14:49:14
Yes, I can paste into Word and Notepad. I can even paste into a new e-mail in Outlook. I just cannot paste into the search bar in Outlook. thanks!

Report •

#3
July 18, 2014 at 08:16:48
✔ Best Answer
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.


Report •

Related Solutions

#4
July 23, 2014 at 14:00:25
Thank you DerbyDad03. I was able to skip steps 2-4, so only had to do steps 1 and 5. Still a pain, but it worked and it just takes a few extra seconds. Thanks for the response!

Report •

#5
July 23, 2014 at 15:36:48
I'm glad you found a solution, but I'd still like an answer to my questions. It might help someone who searches the archives for a similar problem.

How did the incident number get into the spreadsheet - Manually entered? Copied from another source? Downloaded from an external source?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question