I glanced through the threads and didn't see this covered. So apologies if I missed it.
I'm looking to take data from an Excel spreadsheet (xls or csv) and import it into individual appointments on an Outlook calendar. The fields my file has need to be mapped to the Outlook fields of Subject, Start_Date, Start_Time, End_Date, End_Time, Categories, and Description. I'd like to accomplish this with a macro and I'm not sure of the code I need to do that. Not sure if I'd also have to identify the actual calendar name or not. If so, for the sake of testing I'll call it "Test Calendar." Attaching the sample .xls file, however the file could be csv; doesn't really matter because I can gather my data in either format. .xls would probably save a step, though. I'm using Outlook and Excel 2013.
Thanks in advance for the help with this Outlook macro. Let me know if there are questions, or something isn't clear.
Reply With Quote
