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!