importing an Excel document to Outlook Calendar

[Guest]

I've named a range on the Excel document, but when I try to import it gives
me an error message that tells me I need to name a range.

 

[Milly Staples [MVP - Outlook]]

Try this, create an item in Outlook's Calendar - export it to Excel and
compare the documents. Massage yours to match the Outlook format and try it
again.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Dawn asked:

| I've named a range on the Excel document, but when I try to import it
| gives me an error message that tells me I need to name a range.

 

[Guest]

Try this, create an item in Outlook's Calendar - export it to Excel and
compare the documents. Massage yours to match the Outlook format and try it
again.

--Â
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Dawn asked:

| I've named a range on the Excel document, but when I try to import it
| gives me an error message that tells me I need to name a range.

After much massaging, it did work. Thank you so much. Hopefully, I'll remember everything I did the next time I have to do it! Thanks, again!

 

[Milly Staples [MVP - Outlook]]

Glad it worked for you!

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Dawn asked:

| "Milly Staples [MVP - Outlook]" wrote:
|
|| Try this, create an item in Outlook's Calendar - export it to Excel
|| and
|| compare the documents. Massage yours to match the Outlook format
|| and try it
|| again.
||
|| --Â
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. All
|| unsolicited mail sent to my personal account will be deleted without
|| reading.
||
|| After furious head scratching, Dawn asked:
||
||| I've named a range on the Excel document, but when I try to import
||| it gives me an error message that tells me I need to name a range.
||
|| After much massaging, it did work. Thank you so much. Hopefully,
|| I'll remember everything I did the next time I have to do it!
|| Thanks, again!

 

[Guest]

I am importing from Excel to calendar and it is only picking up the first
month of information and no more. I have seen a date range box come up
before but now I don't.

 

[Sue Mosher [MVP-Outlook]]

Make sure your named range in Excel covers all the data you want to import.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Guest]

I've read the solutions, but i don't get it. where do i put the named ranges
in the excel page? please help?

 

[Milly Staples [MVP - Outlook]]

If you have exported Outlook items to Excel, and have your Excel spreadsheet
open, what about comparing the two items is hard to understand? What
exactly are you asking? Look at the two of them, compare the data layout,
and then make yours like the one from Outlook.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, SANMAN07 asked:

| I've read the solutions, but i don't get it. where do i put the named
| ranges in the excel page? please help?
|
| "Milly Staples [MVP - Outlook]" wrote:
|
|| Try this, create an item in Outlook's Calendar - export it to Excel
|| and compare the documents. Massage yours to match the Outlook
|| format and try it again.
||
|| --Â
|| Milly Staples [MVP - Outlook]
||
|| Post all replies to the group to keep the discussion intact. All
|| unsolicited mail sent to my personal account will be deleted without
|| reading.
||
|| After furious head scratching, Dawn asked:
||
||| I've named a range on the Excel document, but when I try to import
||| it gives me an error message that tells me I need to name a range.