CSV data to Outlook macro

gbaker · #1 03-26-2013, 12:58 PM

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.

macropod · #2 03-28-2013, 02:38 AM

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.

gbaker · #3 03-28-2013, 05:25 AM

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.

macropod · #4 03-28-2013, 09:17 PM

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

Aside from the Outlook automation, for which you'd need to set a reference to Outlook, the code is taken from the Outlook vba help file. I don't believe creating a CSV file would simplify things.

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