Access to Outlook VBA

Need some VBA code written for an MS Access front end database that will accomplish the following. 1. Selects a record from a linked SQL Server back end table. 2. Checks to see if MS Outlook is open, if it is not open. Open it and leave it open. Once it's open or determined that it's open. Use the data from the selected record-set to do following. [login to view URL] an Appointment on a specific calendar for email account but you will have to locate the correct calendar from several email accounts in the outlook program. Populate the the appointment fields, Subject, Location, Start Time, End Time, and Body with data, including an invitee, display the outlook form showing the invitation to field. and where the appointment is being emailed from. 4. Determine if the this record has already been calendared and sent and if it has cancel request and warn user. 5. must include error trapping. Office 2010 or newer 32 bit Windows 7 Professional or Newer 64 bit