emails into one excel spreadsheet
When you say "about 4 lines": does the number of lines vary from email
to email? If it does not, you could separate the lines into columns
with a formula in each of the target columns: =A1, =A2, =A3, =A4. Then
paste those formulas into row 5, and so forth, and remove blanks by
sorting.
As an alternative, the PST file Outlook uses to store email is a
database. If you use MS Access you can import the PST file (or just a
folder from the PST file) into an Access table, which will provide you
all sorts of info in addition to the text of the email: sender's email
address, send time, receive time, etc.
|