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!

http://www.mail-archive.com/accessvb.../msg00278.html

"Seth" wrote:

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!