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

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

"Keith Mason via OfficeKB.com" wrote in message
...
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.dicks-clicks.com/excel/olTask.htm

/Fredrik

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

Here are some sites that will get you started.

Ron de Bruin's site

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

Dick Kusleika's site

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

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

"Keith Mason via OfficeKB.com" wrote in message
...
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