Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 09-30-2013, 08:50 AM
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

Quote:
Originally Posted by davesp
....I exported an appt from Outlook 2010 to a CSV file. This gave me the Outlook field names (columns) for each piece of data recorded in the Outlook appt. I then enter the relevant data for each field (column) and imported the CSV file into Outlook. It worked great - all 3 years or 36 individual appts were entered in my calendar. However the "RequiredAttendees" field, while populated with a valid e-mail address did not come through. It is not in my appt and thus the person I wanted to invite to this meeting did not get the appt....I tried to import to the Outbox, thinking it may have to be sent to the invitee, but that did not work. I tried sending it to the sent folder, that too did not work.
Sorry for my earlier reply; you did say you were importing it back into Outlook after the mod, not into Excel, but I didn't notice.

But then, if the email address is getting into the CSV correctly, and then not making it into Outlook, it sounds like Excel is acting as you intended and this is a question that should be addressed to the Outlook forum instead.

I haven't seen the CSV yet, but here's a thought: When you export the appointment from Outlook to the CSV, before you change anything, are email addresses appearing in any special format? In quotes, perhaps? If you've triple-checked and you're sure the new email addresses are in the right column(s), then maybe it has to do with something like quote marks.
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 09:31 PM.


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