Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-30-2013, 08:12 AM
davesp davesp 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 64bit
Novice
 
Join Date: Jan 2013
Posts: 17
davesp is on a distinguished road
Default

Hi Bob, thanks for the fast reply. I imported the Excel file to Outlook, which include the e-mail address in the RequiredAttendees field or column. Everything but that data imported correctly.

My assumption is that when that field is populated in the Excel spreadsheet it would also populate the cooresponding field in the Outlook meeting or appt - thus, the recipient would also get the appt notice.

I am not sure how to attached a sample file, but the RequiredAttendees filed does have a valid e-mail address in it.
Reply With Quote
  #2  
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
  #3  
Old 09-30-2013, 09:07 AM
davesp davesp 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 64bit
Novice
 
Join Date: Jan 2013
Posts: 17
davesp is on a distinguished road
Default

Hi Bob, I am agreeing that this is likelk an Outlook issue and will take it to the Outlook forum...

FYI, I should have mentioned previously, that I am at work and we are on an Exchange server-that may have something to do with it.

Anyway, I have tried the e-mail address in the traditional, name@domain.com form as well as the lastname, firstname form used here at work. And I have confirmed the use, or in this case the non-use of quotes.

I attached the test file.

Thanks

Dave
Attached Files
File Type: xls Test Import.xls (23.0 KB, 22 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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 08:18 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