Send meeting request from form

I know how to send emails directly from a form but is it possible to send
meeting requests from outlook directly from a form?

Russ

Hi Russ

Yes, this can certainly be done, but I've never done it myself, so I'm
shooting from the hip here. It involves creating a MeetingItem object
instead of a MailItem.

There is some example code at:
http://msdn.microsoft.com/en-us/vbao...HV05247833.asp

If you need further assistance, you might be better off posting your
question to one of the Outlook newsgroups -
microsoft.public.outlook.program_vba.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"Russell Bauer" wrote in message
...
I know how to send emails directly from a form but is it possible to send
meeting requests from outlook directly from a form?

Russ

Have a look at my code for creating an Outlook Appointment form from Access.

http://www.datastrat.com/Download/OutlookForms2K.zip

Appointment items become Meeting items when they arrive at another users
mailbox.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Russell Bauer" wrote in message
...
I know how to send emails directly from a form but is it possible to send
meeting requests from outlook directly from a form?

Russ

Arvin,
I have code that can create a meeting request. For example, I imported
someones list of softball games. They're at different times and different
days etc., so I used a looping command to add the list as individual
requests. The recipients just had to accept each request. The probem I'm
running into, as you probably guess, is that I have trouble adding a person
to the list because I'd have to go in and manually add the new recipient to
each softball game. Of course, if I can get this to work, I can use it for
work meetings as well.

Is there a way to modify my code so that I can programattically open a
meeting request programatically and add a recipient? If so, then I can imbed
the code into looping command and add the person to all relevant meetings. If
you can figure this out, I will be BLOWN AWAY!!! THANKS!!!!

Here's the relevant excerpt from my code:

Dim objOutlook As Outlook.Application
Dim objAppt As Outlook.AppointmentItem
Set objOutlook = CreateObject("Outlook.Application")
Set objAppt = objOutlook.CreateItem(olAppointmentItem)
objAppt.MeetingStatus = Outlook.OlMeetingStatus.olMeeting

'ADD ATTENDEE
Dim oRecipt As Outlook.Recipient
Dim strRecipients As String
strRecipients = Forms!Dashboard!AddAttendee
With objAppt
'Add the recipient to the Meeting Request
Set oRecipt = .Recipients.Add(strRecipients)
oRecipt.Type = olTo
End With


"Arvin Meyer [MVP]" wrote:

Have a look at my code for creating an Outlook Appointment form from Access.

http://www.datastrat.com/Download/OutlookForms2K.zip

Appointment items become Meeting items when they arrive at another users
mailbox.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Russell Bauer" wrote in message
...
I know how to send emails directly from a form but is it possible to send
meeting requests from outlook directly from a form?

Russ