Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-15-2010, 06:29 PM
Kimberly Kimberly is offline Importing Excell date into Outlook trouble Windows 7 Importing Excell date into Outlook trouble Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

Yes, Outlook requires the range to be named. To do so:

a) Select the range, including all the column labels and all the data
b) Go to the Formulas tab and click ‘Define Name’
c) Verify the ‘Refers to” box lists the correct range
d) Type the desired name… “data”, for example, in the Name textbox. No space characters are allowed. Then click OK to close the ‘New Name’ dialog box
Outlook 2007 also required that the Excel file be a version 97-2003, so you will need to save it as one.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing a .ics file to Outlook Sparky65 Outlook 0 04-07-2010 04:27 AM
Trouble importing from web page into Excel 2007 JHCOLVI Excel 0 02-25-2010 12:18 PM
Having trouble with keywords in Outlook Rule mfarring Outlook 0 02-03-2010 08:17 AM
new appointment date always reverts back to today's date msills Outlook 0 08-24-2007 08:57 AM
Importing Excell date into Outlook trouble Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft