Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 185
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to convert Outlook Journal Duration to a number JRO Mtn Group Excel Worksheet Functions 3 May 10th 07 09:01 PM
how do I import data from outlook to excel Becca Excel Discussion (Misc queries) 1 November 27th 06 06:47 PM
Outlook wants an Excel named range to import contact data why? GDB026 Excel Discussion (Misc queries) 1 December 16th 05 05:59 PM
How to import Outlook Contact data into Excel jee Excel Discussion (Misc queries) 1 October 14th 05 02:29 PM
Label name and Import Data to Outlook Jake Excel Discussion (Misc queries) 0 September 1st 05 05:03 PM


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"