I have a situation where I have emails coming in from a particular email address and I want to copy the data automatically to Excel. The information that I am looking for is located between two lines that look like this: “============”
Each line is comprised of 9 different “columns” with fixed “field widths”. I can copy the information to excel manually and then do a text to columns function but the problem is that I get between 200 to 600 of these emails a day and I don’t have the time to create an excel database manually by copying and pasting from the email. Can anyone help me figure out a method to isolate the specific field widths for each line between the “=====” lines?
