How to Export IMAP Email from Outlook to Excel or CSV Text Files

There are billions of people out there - somewhere...

Unfortunately it’s not possible to export (IMAP) email body’s onto Excel using the Export feature in Outlook.

As a work around, you may export the particular IMAP folder emails as .PST format and then open the same file in Outlook.

To open the PST file, click on file->open->browse to the PST file->click open.

To Export the file, Click on on File > Export to file->Microsoft Excel>Select the PST file.


A "Simple" Speadsheet to generate random products to import into Magento

I created an Excel spreadsheet that auto-generates 10,000 product SKU's from a list of words. I kept getting "#VALUE!" errors using the LOOKUP function in Excel.

The answer was to press CTRL-SHIFT-ENTER when entering the formula! Weird...


By using an "Array Formula" the errors went away! Very pesky bug to chase down, figured I'd post it here.

The weirdest thing, I only got the error after 1,000 rows... And such.


Subscribe to RSS - Excel