S
Sue
Is there anyway to export an Excel spreadsheet directly into Outlook Calendar?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bob I
Open Outlook, File, Import and Export ..................................
S
Sue
I mean this: if you have a spreadsheet that has dates in cell blocks - can
you import those dates into Outlook Calendar and have them show up on the
actual dates?
you import those dates into Outlook Calendar and have them show up on the
actual dates?
B
Bob I
If they are configured properly. I suggest you Open Outlook, and Export
your calendar to Excel file. Now Open the file in excel and look at what
is there. If you want Outlook to not "choke" on the file you will need
to use formats it understands. Excel doesn't "export" Outlook files,
Outlook Imports Excel or other data files. So paste in or configure your
Excel spreadsheet to conform to the Exported calendar layout and you
have it.
your calendar to Excel file. Now Open the file in excel and look at what
is there. If you want Outlook to not "choke" on the file you will need
to use formats it understands. Excel doesn't "export" Outlook files,
Outlook Imports Excel or other data files. So paste in or configure your
Excel spreadsheet to conform to the Exported calendar layout and you
have it.
C
Conan Kelly
Sue,
What do you mean by "dates in cell blocks" in XL? When you say "date" do
you mean "appointment" or some other event that falls on a specific date?
Is you XL spreadsheet set up to look like a calendar for printing out?
Conan
What do you mean by "dates in cell blocks" in XL? When you say "date" do
you mean "appointment" or some other event that falls on a specific date?
Is you XL spreadsheet set up to look like a calendar for printing out?
Conan
S
Sue
Conan - no, actually it's just a spreadsheet with dates in one column, then
the actual event in another column - I'm assuming from what "Bob" says, I
need to create an exact duplicate of how my Oulook Calendar exported to excel
with my new spreadsheet - then, add my new spreadsheet to my Outlook Calendar
spreadsheet, - then, import it back into Outlook....
the actual event in another column - I'm assuming from what "Bob" says, I
need to create an exact duplicate of how my Oulook Calendar exported to excel
with my new spreadsheet - then, add my new spreadsheet to my Outlook Calendar
spreadsheet, - then, import it back into Outlook....
C
Conan Kelly
Sue,
It has been along time since I've done this, and I've only done it once, but
I don't think you need to combine the 2 together. All I think you need to
do is set up the XL sheet (that you want to import) the exact same way as
the one OL exported (same columns, same names, same order.......in fact,
just copy the column labels from OL export and paste into the one you want
to import.
HTH,
Conan
It has been along time since I've done this, and I've only done it once, but
I don't think you need to combine the 2 together. All I think you need to
do is set up the XL sheet (that you want to import) the exact same way as
the one OL exported (same columns, same names, same order.......in fact,
just copy the column labels from OL export and paste into the one you want
to import.
HTH,
Conan
S
Sue
THANKS !!! Worked perfectly....
Conan Kelly said:Sue,
It has been along time since I've done this, and I've only done it once, but
I don't think you need to combine the 2 together. All I think you need to
do is set up the XL sheet (that you want to import) the exact same way as
the one OL exported (same columns, same names, same order.......in fact,
just copy the column labels from OL export and paste into the one you want
to import.
HTH,
Conan
L
Leno
Sue said:Is there anyway to export an Excel spreadsheet directly into Outlook Calendar?