#1
|
|||
|
|||
CSV data to Outlook macro
I have a CSV file that I would like to start a macro that would take the file, open outlook, export the data to the an outlook calendar, map the field and then close outlook and return to the excel CSV file.
Is that possible and do you have any existing code out there that I could start with. |
#2
|
||||
|
||||
How is this an Excel problem? A CSV file is just a comma-delimited text file. An Outlook coder should be able to import the data from such a file without involving Excel. That said, no-one could write the code based on what you've posted. For starters, anyone doing the coding would need to know the CSV file's structure.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
CSV data to Outlook macro
Hi Macropod,
I wanted to use an excel workbook to imupt the information, send the list to a CSV so it could be imported into an outlook calendar. The user would only have to input the information in the excel workbook and then click a button that would create the CSV, open outlook and import the information to a calendar to be viewed by others in the group showing available time open for seminars or webinar. I have attached the sheet I'm working on which is the same sheet I sent you to clear the drop down boxes. I figure it's probably not possible to cross platforms but thought I would ask anyway. |
#4
|
||||
|
||||
Hi Gay,
First off, I don't see any particular reason to involve a CSV file, as you can populate an Excel calendar directly from Excel. The following code shows how you might do that, though nothing in the workbook is referenced (you'd presumably want to reference your dropdowns - but you don't seem to have one for the date). Code:
Sub Demo() Dim objOutlook As Outlook.Application Dim objApptItem As Outlook.AppointmentItem Dim OlAttendee Set objOutlook = New Outlook.Application Set objApptItem = objOutlook.CreateItem(olAppointmentItem) With objApptItem .AllDayEvent = False .MeetingStatus = olMeeting .Subject = "Strategy Meeting" .Location = "Conference Room B" .Start = #9/24/2002 1:30:00 PM# .Duration = 90 Set OlAttendee = .Recipients.Add("Nate Sun") OlAttendee.Type = olRequired Set OlAttendee = .Recipients.Add("Kevin Kennedy") OlAttendee.Type = olOptional Set OlAttendee = .Recipients.Add("Conference Room B") OlAttendee.Type = olResource .Display End With End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro - Get External Data From Web | Wries | Excel Programming | 1 | 10-31-2012 08:00 AM |
Macro to recap data of same numbers | Jasa P | Word VBA | 0 | 06-28-2012 02:41 AM |
Consolidating data using Macro | mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |
Word Macro to get pdf data appended | janith | Word VBA | 1 | 04-18-2012 12:48 AM |
Importing data from excel using a macro | soma104 | Word | 1 | 04-14-2011 05:10 PM |