Format the “Start Time” and “End Time” columns as time from F5:G27.
Format the “Start Date” and “End Date” columns as a short date from D5:E27. Select and shade the area that you want to use to enter your calendar information. Shade all of the fields one color and make them bold. 
I chose Subject, Location, Description, Start Date, End Date, Start Time, End Time, All Day Event, and Categories. Just because you add a non-required field, does not mean that you have to use it every time.
Starting in row 4, enter all of the fields that you want to use. In cell A1, title the template as “Calendar Upload Template” and format it as bold. Feel free to add whatever other fields that you routinely use. It is important to at least to use the following fields: Subject, Start Date, End Date, Start Time, End Time, and All Day Event. The “Upload” tab is where the calendar information is entered. I decided to format my tables by shading them and adding a border around them, but that is totally up to you. In the “Name Box," enter “Category” as the name for this selection. Highlight the entire area from E4 through the end of your list. It is critical that they are spelled the exact same way in Outlook and Excel. 
Enter the categories into Excel and sort them alphabetically once you are finished entering them. You can add as many categories as you like, although, there are only 25 different colors in Outlook. I would highly recommend renaming them something useful. The default categories are based on color. 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 kommentar(er)
