Exporting data from Excel to Outlook Calender

S

Sandra

Is there anyway of exporting data from an Excel spreadsheet, in this case, dates for deadlines of document completion, into the calender of Outlook, so an automatic alert would be generated in Outlook for the deadline

Sandra
 
P

Patrick Reed [MVP - Outlook]

In Outlook, if you select File | Import and Export | Export to a file |
Comma Separated Values (Windows)... you can make a CSV file to use as a
template. This will give you a CSV file that can be modified in Excel with
the proper fields you can use. From there, it's just a matter of removing
the data you don't want, adding the data you do want into the appropriate
fields (columns), and then importing it into the Calendar through File |
Import and Export.

--
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!



Sandra said:
Is there anyway of exporting data from an Excel spreadsheet, in this case,
dates for deadlines of document completion, into the calender of Outlook, so
an automatic alert would be generated in Outlook for the deadline?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top