Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 09-30-2013, 12:01 PM
BobBridges's Avatar
BobBridges BobBridges is offline How to import excel calender data into outlook - with a click of a button Windows 7 64bit How to import excel calender data into outlook - with a click of a button Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Ok, so now that I know how (thanks for showing me—and I agree, a silly place for doing exports, but I never looked further than File anyway, didn't think of Open much less Import), I tried exporting my own appointments to CSV.

Now, I notice you said you "confirmed the use, or in this case the non-use of quotes". Does that mean that in the CSV that you're trying to import back into Outlook, the email addresses (in column 11) do not have quotes around them? I'm being so specific because when I export my own appointments to CSV, there are email addresses in column 11; besides the header row there are two records, and in both appointments the email values are in double quotes. In the first there are multiple comma-separated addresses and some of them are names only, eg Bob Bridges (so I presume Outlook feels free to look them up in my contacts book), but others are email addresses; and in the other appointment the only entry is
Code:
...,"RBridges@infosecinc.com",...
...with the quotes. (That's my work address.) I infer that the quotes are necessary at import time. But you say you confirmed the non-use of quotes, so I'm suspicious.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel? mag Excel 0 10-18-2012 11:15 AM
Import excel data in to SQL Server DavidBrown Excel 0 08-08-2011 04:49 AM
How to import excel calender data into outlook - with a click of a button Unable to sync iphone calender with outlook calender!! Reltub Outlook 5 07-26-2011 02:55 AM
Import Pics and Excel Data into PP? jawillyams PowerPoint 0 03-13-2011 01:03 PM
How to import excel calender data into outlook - with a click of a button Outlook data import Cunner Outlook 2 08-20-2010 02:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 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