Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / April 2005

Tip: Looking for answers? Try searching our database.

Meeting request

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Carole - 07 Apr 2005 18:17 GMT
what code do I use to send a meeting request by e-mail using VBA in Access
2000.

Thank you in advance

Carole
Al Camp - 08 Apr 2005 00:07 GMT
Carole,
  Try the SendObject function.
Al Camp

> what code do I use to send a meeting request by e-mail using VBA in Access
> 2000.
>
> Thank you in advance
>
> Carole
Rob Oldfield - 08 Apr 2005 00:31 GMT
Stolen from an old post by Cheryl Fischer... needs a reference to the
Outlook library.  Works for me except pops up a warning saying that a
program is about to send a message on my behalf...
Sub SendReq()Dim objOApp As New Outlook.Application
Dim objAppt As AppointmentItem
Dim oExp As Outlook.Explorer

Set objOApp = New Outlook.Application
Set objAppt = objOApp.CreateItem(olAppointmentItem)
Set oExp = objOApp.Session.GetDefaultFolder(olFolderInbox).GetExplorer

With objAppt
   .RequiredAttendees = "Addressee(s) Name(s)"
   .Subject = "Subject of Meeting/Appointment"
   .Importance = 2         ' high
   .Start = YourDateField & " " & IIf(IsNull(YourTimeField), " 8:00",
YourTimeField)
   .Location = "Location of Meeting"
   .Body = "Additional information to appear in body"
   .MeetingStatus = 1
   .ResponseRequested = True
   '.Save  'Uncomment if you want message saved to your sent items folder
   .Send
   MsgBox "Item sent."
End With

Exit_btnSendItem_Click:
   Set objOApp = Nothing
   Set objAppt = Nothing
   Set oExp = Nothing
End Sub

> what code do I use to send a meeting request by e-mail using VBA in Access
> 2000.
>
> Thank you in advance
>
> Carole
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.