Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import data from Excel into Outlook journal
I have exported data from the Outlook Journel into an Excel spreedsheet and
now want to import it back into Outlook journal. I have tried using the spread sheet save as three kinds of files ( xls. cvs. and txt. file formats) saving only the one sheet with data formatted from the orignal export. Outlook will not import any of these into the journal. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import data from Excel into Outlook journal
Derek
You should be able to do this as an xls file but you are best to highlight the data and name the range first (You can simply click in the name box, top left by the formula bar and type the name and press enter. now save and close the Excel file, go into Fileimport... in outlook and select the xls and then it should offer the range name, select the Calendar folder and map the fields if necessary -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non tech): www.nickhodge.co.uk/blog "Derek Worley 19" <Derek Worley wrote in message ... I have exported data from the Outlook Journel into an Excel spreedsheet and now want to import it back into Outlook journal. I have tried using the spread sheet save as three kinds of files ( xls. cvs. and txt. file formats) saving only the one sheet with data formatted from the orignal export. Outlook will not import any of these into the journal. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to convert Outlook Journal Duration to a number | Excel Worksheet Functions | |||
how do I import data from outlook to excel | Excel Discussion (Misc queries) | |||
Outlook wants an Excel named range to import contact data why? | Excel Discussion (Misc queries) | |||
How to import Outlook Contact data into Excel | Excel Discussion (Misc queries) | |||
Label name and Import Data to Outlook | Excel Discussion (Misc queries) |