This lets you look at the native text of the file.
But you can right click on a CSV, Select "Open with" and point it to Notepad or you can open a Notepad window, then drag-and-drop the CSV icon to that window.
#Import calendar to outlook from csv windows#
When you double-click on a CSV document, Windows knows it's a kind of Excel workbook and by default (unless you change the association for the. If you already know this then don't take offense, but just in case you didn't: A CSV file is a plain-text "unload" (so to speak) of the contents of a workbook. You haven't yet made the distinction between how they look in the CSV and how they look once they're read into Excel, so I suspect you haven't noticed it yet. But when I open them with Notepad, both addresses are in double quotes. In Excel, the required attendee (my email address) is in col 11, and the optional (your address) is in col 12. I wondered whether you were using a different export format than I, but they're the same, so that's one theory down. They seem identical in both CSV (viewing in Notepad) and when loaded into Excel. I accepted the invitation, then exported it twice: once to CSV (Windows) and once to CSV (DOS). 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. 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.īut 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 tried sending it to the sent folder, that too did not work. 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. However the "RequiredAttendees" field, while populated with a valid e-mail address did not come through. It worked great - all 3 years or 36 individual appts were entered in my calendar. I then enter the relevant data for each field (column) and imported the CSV file into Outlook. This gave me the Outlook field names (columns) for each piece of data recorded in the Outlook appt. I exported an appt from Outlook 2010 to a CSV file. If you would like to have some help with the macro in Excel, please post a sample of the input data. I hope this is enough to get you started. The Import process is a little laborious the first time, but after that, Outlook will remember the settings. Once this is done, your user can open Outlook and import the data in this file (the Import & Export command will first need to be added to their Outlook ribbon if using v 2007 or above). You may want to write a simple macro in Excel to select the flagged records and massage the data into the correct output structure in a separate file (Excel 97-2003. You can obtain Outlook's field names, and the default data settings for fields you don't use, by exporting a (small!) calendar from Outlook to Excel format.
If the column headings (field names) are the same as those used by Outlook, they will not have to be mapped later. In Excel, you will need to arrange your data in a table, with individual appointments on each row.
Because of this, I suggest the user flags all required items rather than doing this one appointment at a time. There will be two parts to this solution: preparing the data in Excel and importing it into Outlook.
0 kommentar(er)
