View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Seth Seth is offline
external usenet poster
 
Posts: 22
Default Create Outlook Meeting Request from Excel

I am trying to write a macro that will send a variable person a meeting
request in Outlook using data from an excel spreadsheet. I am able to parse
the spreadsheet for the person (or their email address) and a date, but I
don't know how to then use that information to automatically create an
Outlook meeting request with the date from a variable called "Dte" and
message title from a variable I called "Title". Here is what I have:

Range("N5").Select
Cells.Find(What:="C1", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext,
MatchCase:=False _
, SearchFormat:=False).Activate
On Error Resume Next
Tmprow = Selection.Row
Tmpcolumn = Selection.Column
Person = Cells(Tmprow, 1)
Dte = Cells(5, Tmpcolumn)
Title = Person & " has a meeting on " & Dte

Thanks in advance!