CSV data to Outlook macro

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