Hi,
I've tried to search for solutions but to no avail. I have an Excel Online (365) file which contains all emails that entered a shared mailbox. I've created a search box to allow the user to type a specific word to search for emails that contained the text in the body of the email. All works perfectly fine including the output. However, I'd like to read the body of the email from the output but it seems the dynamic filter doesn't allow me to view all characters on the field? I'm unable to view the entire body of the email without trying to expand the row height/width. If there are 1000s of emails, I'll need to expand each cell to view the entire text in the cell. I tried to also click on the cell to view the email from the excel formula bar but this only shows the dynamic filtering formula?
Any suggestions on how I can make this work or user friendly? Any advice or help is greatly appreciated.
Thanks
I've tried to search for solutions but to no avail. I have an Excel Online (365) file which contains all emails that entered a shared mailbox. I've created a search box to allow the user to type a specific word to search for emails that contained the text in the body of the email. All works perfectly fine including the output. However, I'd like to read the body of the email from the output but it seems the dynamic filter doesn't allow me to view all characters on the field? I'm unable to view the entire body of the email without trying to expand the row height/width. If there are 1000s of emails, I'll need to expand each cell to view the entire text in the cell. I tried to also click on the cell to view the email from the excel formula bar but this only shows the dynamic filtering formula?
Any suggestions on how I can make this work or user friendly? Any advice or help is greatly appreciated.
Thanks
