Outlook admin vs individual access (VBA pulling info)

Status
Not open for further replies.
K

ker_01

I'm not looking for a specific solution, just information on whether or not

this is possible, and if so, some general leads on what I'd need to learn

more about in order to develop and implement.

I have a VBA macro that grabs appointment data

(time/date/duration/subject/etc). As an individual user, it only pulls this

information from my calendar.

We are considering a project where employees would start using custom labels

to document their time on different projects, and ideally we would be able to

pull all of that data at once (not require each user to pull their own

summary data). In my mind, that means someone with some level of IT

administrative access who can access all calendars to pull this data - even

if the individual users have not specifically shared their calendars.

Has anyone pulled data at this aggregate level before, and if so, what are

the major stumbling blocks I should look out for, and what would I need to

learn more about to adapt VBA code from use at an individual level up to

something usable by an IT administrator to pull all calendars?

Thank you,

Keith
 
K

Ken Slovak - [MVP - Outlook]

You don't say what version or versions of Outlook you intend to support, or

if you have Exchange or not.

In Outlook 2007 or later calendar labels have been deprecated from the UI in

standard appointment forms. Labels never were exposed in the Outlook object

model, although they are accessible using other API's. So you'd need a

custom form to show a label in a drop-down or other control.

If you have Exchange you can have code that accesses each mailbox and reads

the desired data. If you don't have Exchange you should not even think about

something like this, you need to start looking at other ideas. PST files

aren't designed to be shared, nor should they ever be accessed from a

network share or anything other than a local hard drive.

I've aggregated such data many times, but never using VBA code. VBA code is

not designed to be deployed it's for prototyping and for personal macros. I

would probably use either C# or VB.NET for this, although something like VB6

could be used if you don't need 64 bit code for Exchange 2010.

How the data would be accessed, even with Exchange, depends on Exchange

version. It could be using Extended MAPI, Redemption

(www.dimastr.com/redemption), WebDAV with DASL or EWS (Exchange Web

services) depending on Exchange version and your familiarity with the

various API's.

"ker_01" <ker01> wrote in message

news:E7266A4C-0709-45E9-8C8B-E85ACBDC46CB@microsoft.com...
> I'm not looking for a specific solution, just information on whether or
> not
> this is possible, and if so, some general leads on what I'd need to learn
> more about in order to develop and implement.

> I have a VBA macro that grabs appointment data
> (time/date/duration/subject/etc). As an individual user, it only pulls
> this
> information from my calendar.

> We are considering a project where employees would start using custom
> labels
> to document their time on different projects, and ideally we would be able
> to
> pull all of that data at once (not require each user to pull their own
> summary data). In my mind, that means someone with some level of IT
> administrative access who can access all calendars to pull this data -
> even
> if the individual users have not specifically shared their calendars.

> Has anyone pulled data at this aggregate level before, and if so, what are
> the major stumbling blocks I should look out for, and what would I need to
> learn more about to adapt VBA code from use at an individual level up to
> something usable by an IT administrator to pull all calendars?

> Thank you,
> Keith

>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
W Outlook 2016 MSI - Possible to make work with O365 modern Auth & Win7? Using Outlook 2
T Outlook roaming signatures Using Outlook 4
S Adding a recipient's column to Sent folder in Outlook 2010 Outlook VBA and Custom Forms 1
J Outlook search bar in Office 2021 Professional Using Outlook 0
J PSA: How to create custom keyboard shortcut for "Paste Unformatted Text" in Outlook on Windows Outlook VBA and Custom Forms 1
C How to fix outlook continuing to prompt fo an Exchange password Using Outlook 0
C Outlook doesn't feel reliable, anymore Using Outlook 5
J Outlook 2016 Trying to get Outlook 2016 to work with Office 365 Using Outlook 0
C Outlook 365 Copy/Save Emails in Folder Outside Outlook to Show Date Sender Recipient Subject in Header Using Outlook 0
U Outlook not responding when trying to print Emails Using Outlook 5
O How to sync (one way) contacts between two Outlook (exchange) accounts? Using Outlook 0
S Sync Outlook (2021) tasks with Microsoft To Do Using Outlook 1
L Duplicate calendar entries in Outlook 365 Using Outlook 4
V Outlook 2021 Can anyone explain why my Outlook views keep changing?! Using Outlook 2
AlphonseG Outlook 365 Outlook Crashes on setting SaveSentMessageFolder Outlook VBA and Custom Forms 5
S Outlook 2021 How to customize colors Outlook 2021 & Office 2021 on PC Using Outlook 2
D Outlook 2007 Recovering E-Mails Using Outlook 0
G Stop Outlook 365 adding meetings to calendar Using Outlook 2
HarvMan Using Emojis in Outlook 365 Using Outlook 3
T Outlook 2019 Not Using Auto Compete After Deletion of 365 Using Outlook 1
D Gmail mail is being delivered to a different email inbox in Outlook App 2021 Using Outlook 2
Albert McCann Outlook 2021 Outlook Display of HTML Email from two senders is glitchy Using Outlook 0
richardwing Outlook 365 VBA to access "Other Actions" menu for incoming emails in outlook Outlook VBA and Custom Forms 0
J Unable to delete folders in Outlook 2019 / Windows Using Outlook 1
K Outlook for Mac problems Using Outlook 0
D Outlook app 2021 & iCloud PST issues Using Outlook 2
M c# vsto Outlook.ApplicationEvents_11_NewMailEx Outlook VBA and Custom Forms 1
J Event/Meeting in Outlook Does Not Align with SharePoint Calendar Using Outlook 5
Christopher M Is it me, or is Outlook 365 BUGGY? Using Outlook 3
U Outlook on the iPhone cannot approve filtered Emails Using Outlook 0
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 1
J Outlook Rules VBA Run a Script - Multiple Rules Outlook VBA and Custom Forms 0
Horsepower Cannot delete gmail in iPhone Outlook outbox Using Outlook 1
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
M Understanding Outlook Identities Using Outlook 1
kburrows Outlook or Phone Combining Contacts? Using Outlook 0
P Outlook 2013 search no longer works Using Outlook 2
M Accessing ALL Outlook contact fields Outlook VBA and Custom Forms 3
C Outlook (desktop app for Microsoft365) restarts every time I save my VBA? Using Outlook 0
R MailTips and older Outlook versions Using Outlook 0
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10
C How to import Outlook calendar? Using Outlook 1
HarvMan Outlook 365 loses "outlook.com" exchange server settings Using Outlook 2
HarvMan Outlook.com Account Using Outlook 3
D Office 365 Outlook desktop app prompts for all account passwords on startup Using Outlook 6
D Alerts in outlook Using Outlook 1
richardwing Auto forward email that is moves into a specific outlook folder Outlook VBA and Custom Forms 5
L Recommendations for Utility to Backup Outlook 365 Account Settings Using Outlook 2
J Recommendations for Outlook Duplicate Email Remover Using Outlook 6

Similar threads

Top