Importing is the process of taking data from programs, such as Excel, and bringing this data into another program, such as Outlook. You can import calendar items (appointments) into your Outlook Calendar very easily by following the procedure in this document.
Import Process
Once you have created and saved a CSV file that includes the columns needed for import, follow these steps to import your calendar data.
1. In Outlook, select File > Import and Export... from the menu bar.
2. In the Import and Export Wizard dialog box, select Import from another program or file and click Next.
3. In the Import File dialog box, select the desired file format, e.g. Microsoft Excel and click Next. Note: you may be prompted to install a piece of software called the Microsoft Office Outlook translator, if so, click Yes to install.
4. Click the Browse button and navigate to where the import file is stored on your machine or network. Select the desired import file.(test.xls is my CSV file).
5. Under Options, select Allow duplicates to be created and click Next.
6. Under Select destination folder, select Calendar and click Next.
7. The next window is typically used for mapping the spreadsheet data to the field names in Outlook. If you have named your fields exactly as stated above, you will not need to map your fields. However, if you did not name the fields as stated above, you must click Map Custom fields… and complete the next window before completing the import process.
8. Click Finish. Once the import process has completed successfully, your appointments will appear in your Outlook Calendar.

No comments:
Post a Comment