Click on the “Categorize” icon and a list of all of the categories that have been set up will appear. They can be found in Outlook by going to the calendar section and opening up a new appointment. In cell E3, enter “Categories." Starting in E4, enter all of the categories that you use in Outlook.Highlight B4:B5, and in the “Name Box” in the upper left-hand corner of the screen and name that section “ADE." ![]() In cell B3, enter “All Day Event." In cells B4 and B5, enter “Yes” and “No” respectively.Rename one of the tabs “Control” by right-clicking on a tab and selecting “Rename.".Open a new workbook in Excel and save it as “Calendar Upload.xls." It is vitally important to save it as an “Excel 1997 – 2003 Workbook” because Outlook can only update the.
0 Comments
Leave a Reply. |