exporting to Outlook 2000

jtrade

New Member
Joined
Oct 25, 2002
Messages
1
Forgive me if this is too basic a question for this forum, to which I am new. Prior to reformatting my W2000 hard drive this weekend, I exported my Outlook 2000 inbox, sent items & contacts to 3 Excel 2000 files, using the Outlook Import / Export wizard. I naively figured that it would be a straightforward process of using the same wizard in reverse to restore my data. What actually happens is that the 3,000-odd inbox emails are all stored in no particular order in one untitled folder (my standard setup is to store in folders sorted by sender)and the contacts list now has a big list of names before the usual A-Z categories without any address details. The imported emails have only a few lines of text, with no sign of any attachments. I have not tried importing the Sent Items, but have deleted the non-functional imported data, which is still sitting within Excel.
Does anyone please know how I have to reformat the 3 Excel files such that they will import back into the relevant Outlook folders (eg. the Inbox emails sort themselves by sender)? Thanks, J.
This message was edited by jtrade on 2002-10-26 11:05
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Anne Troy

MrExcel MVP
Joined
Feb 18, 2002
Messages
2,603
I don't believe you CAN export EMAILS to Excel.

You can export contacts and such.

NEXT time...copy any PST files on your hard drive before wiping. THOSE are ALL your emails, contacts, everything. And you just hook Outlook back up to it when you get going again.

Wish I had something nice to say. Sorry.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,109
Messages
5,628,758
Members
416,337
Latest member
tl3phd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top