How can I programme excel to create and send an outlook meeting request?

Please can anyone help....I want to be able to programme excel (using the
Visual Basic Editor) to start up outlook, create a meeting request, and
then send it out to a group of people. This is for Office 2003. I cannot
work out how to do it...........Please Help!

--
Message posted via http://www.officekb.com

Here are some sites that will get you started.

Ron de Bruin's site

http://www.rondebruin.nl/sendmail.htm

**** Kusleika's site

http://www.*****-clicks.com/excel/olSending.htm

These will provide the basics.
--
Regards,
Tom Ogilvy

"Keith Mason via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> Please can anyone help....I want to be able to programme excel (using the
> Visual Basic Editor) to start up outlook, create a meeting request, and
> then send it out to a group of people. This is for Office 2003. I cannot
> work out how to do it...........Please Help!
>
> --
> Message posted via http://www.officekb.com

"Keith Mason via OfficeKB.com" <[email protected]> wrote in message
news:[email protected]...
> Please can anyone help....I want to be able to programme excel (using the
> Visual Basic Editor) to start up outlook, create a meeting request, and
> then send it out to a group of people. This is for Office 2003. I cannot
> work out how to do it...........Please Help!
>
> --
> Message posted via http://www.officekb.com

Here's a link with code that should get you started
http://www.*****-clicks.com/excel/olTask.htm

/Fredrik