X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Append Outlook Calendar Data To Access, Excel Or Sharepoint, Any Version    
post Feb 19 2020, 01:47 PM

Posts: 11
Joined: 5-October 16


We are trying to collect and report data based on certain meeting invite data. I'm looking to use VBA or rules, etc to be able to append fields of Outlook calendar invite data to Access or Sharepoint or even Excel. Ideally, I'm grabbing the host name, the date and time the invite was sent, teh date and time of the meeting as well as the subject line. I'm open to what program it gets appended to bc I can then grab that data and do whatever I need. I think it would be easier to append to sharepoint but I'm open to ideas.

The way I would use it is to have a group of staff requesting approval meetings and copying an outlook calendar that would be invited to ALL of the meetings. I would then link to the file or create a rule that runs VBA, etc to append these fields to a data set.

Can you advise on how you go about this and - ideally - give me some example code or links so I can learn?

Alternatively, if there is a way to do this in reverse by using SharePoint and Sharepoint sends the calendar invite, I'm open to that. I have seen that the Sharepoint flows are not well integrated with Outlook calendars.

Note that some some users are using Windows 2007 and some O365 but if that is a barrier, we can accelerate movement to O365.

Go to the top of the page
post Feb 19 2020, 02:41 PM

UtterAccess VIP
Posts: 7,241
Joined: 30-June 11

Did you see https://www.UtterAccess.com/forum/index.php...t&p=2743908 ?

Daniel Pineault (2010-2019 Microsoft MVP, UA VIP, EE Distinguished Expert 2018)
Professional Help: https://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: https://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc

All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    29th March 2020 - 10:19 AM