I'm a new VBA user and have been trying to learn how to expor
information from a particular worksheet to Outlook calender. i hav
read the tutorial on www.dicks-clicks.com and have gotten that to wor
just fine. What I'm running right now is (i'm want to use late bindin
as opposed to early binding):

Private Sub CommandButton2_Click()

Dim olApp As Object
Dim olApt As Object

Set olApp = CreateObject("Outlook.application")
Set olApt = olApp.CreateItem(1)

With olApt
.Start = Date + 1 + TimeValue("19:00:00")
.End = .Start + TimeValue("00:30:00")
.Subject = "Piano lesson"
.Location = "The teachers house"
.Body = "Don't forget to take an apple for the teacher"
.BusyStatus = 2
.ReminderMinutesBeforeStart = 120
.ReminderSet = True
.Save
End With

Set olApt = Nothing
Set olApp = Nothing

End Sub

How to I use information from particular cells as opposed to typing i
in VBA. for example, instead of ".Start = Date + 1
TimeValue("19:00:00")" how would i have it pull the data from, say
cell E1 (which could be simply be "6/6/05" for example). so, basicall
i'm looking for .Start=E1. I also want the other information to b
pulled from other cells. so instead of typing ".Body = "Don't forget t
take an apple for the teacher'" how do I get .Body to pull and displa
the text from cell E2 for example. Much thanks to those that help m
solve my quandary

--
littlegreenmen
-----------------------------------------------------------------------
littlegreenmen1's Profile: http://www.excelforum.com/member.php...fo&userid=2397
View this thread: http://www.excelforum.com/showthread.php?threadid=37689