Importing Text from Outlook into Excel
There are a number of ways of importing from Outlook to Excel. Most require
a macro. You can simply try copying and pasting the data and then rearanging
the data in excel. Other method you can use is to export the data from
outlook to a text file (like csv) and then importing the data into excel.
Without more details there is no simple answer.
"Daren" wrote:
Hello. Is there a way to import text from an e-mail into Excel? The format
of the text in outlook includes numbers, addresses, city, state, zip code,
and other text. Is there a way to import this information from an Outlook
e-mail into Excel and transpose it as one row in Excel?
|