Although the right code can help Office applications talk to one another, sometimes it’s quicker to export data. An automated solution is definitely worth the effort if users must frequently repeat the task. Knowing which format to export to is the REAL trick. You can export OUTLOOK data to another format as follows:

• Choose Import And Export from the File menu.
• In the resulting pane, select Export To A File and click Next.
• From the Create A File of Type list, choose the appropriate file type and click Next. One of the seven types should be adequate for most purposes.
• Choose the folder you want to export from and click Next.
• Enter the path and filename for the EXPORTED file and click Next. Or click Browse to locate the appropriate folder and then enter just a filename.
• Click Finish. In this final window, Outlook MAY give you the opportunity to map fields. GENERALLY, you won’t need to change the wizard’s settings unless you have very specific reasons for doing so.
• Outlook exports internal field names. You can change these names in the exported file, but you can’t change them before the export. You can use an export to learn the internal names if you decide to code the solution later. Knowing those internal field names is essential.

Although the right code can help Office applications talk to one another, sometimes it’s quicker to export data. An automated solution is definitely worth the effort if users must frequently repeat the task. Knowing which format to export to is the real trick. You can export Outlook data to another format as follows: