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.