I receive emails with multiple lines that I need to copy and paste into Excel, e.g.:
A B C
1 Johnny Appleseed 4/15/99
I've written the code that can parse and input the data into cells. But I can't figure out how to copy and paste from the email. Trying to use an inputbox only allows me to capture the first line as there are carriage returns in the email. How can I create a multi-line box that will accept copy and paste?