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
[login to view URL]
I have gone through your project requirements. I will write VBA code in your access program to create appointments in outlook calendar/s as per your request.
I have created many outlook macros and add-ins also. I also know how to automate Outlook via access.
My ratings and reviews will give confidence in me
I will do the project within 2 days only
Thanks for your time
Regards
Prashant
$155 USD en 3 días
5,0 (510 comentarios)
7,3
7,3
3 freelancers están ofertando un promedio de $140 USD por este trabajo
I have bachelor and master degrees in IT. My Primary skills include Java, Python, VB/.NET, ArcGIS, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration and maintenance with Linux/Unix and Windows Networking.