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
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 9
K Outlook 365 After migrating to Outlook 365, some contacts display in emails with prefixes Using Outlook 0
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 1
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 4
C How to import Outlook calendar? Using Outlook 0
HarvMan Outlook 365 loses "outlook.com" exchange server settings Using Outlook 1
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
O Outlook - How to embed font ? (If at all possible) Using Outlook 2
Z New minimum Outlook for Windows version requirements for Microsoft 365/Exchange Online Using Outlook.com accounts in Outlook 16
T How to configure Outlook for two users on a single Windows account Using Outlook 3
R Outlook 2021 Having problem setting up outlook 2021 with windows 11. I have 3 gmail accounts and I want the 3 gmail, emails to merge into the same outlook input. Using Outlook.com accounts in Outlook 0
e_a_g_l_e_p_i Outlook 2021 all appointments not showing in calendar Using Outlook 2
S Outlook 365 Can I change the possible range of highlighting colours when writing an Outlook email? Using Outlook 1
B Outlook 213 keeps crashing. I just found out there are DMP files. How can I tell Why? Using Outlook 2
H Outlook 2016 related mails in outlook Outlook VBA and Custom Forms 13
S Outlook 2021 Can you make emails from 3 word domains "safe" by entering top 2 word domain into Safe List in Outlook? Using Outlook 1
@ Outlook Using Outlook 2
kburrows Outlook 365 - Ribbon Customizations Disappear Using Outlook 0
D Wishlist How to use 'app password' in Outlook 2003 after Google pulled plug on "less secure apps" Using Outlook 2
L Restoring Outlook from backup pst file Using Outlook 5
e_a_g_l_e_p_i Kernel Outlook .pst viewer Using Outlook 3
L Outlook 365 Outlook not working on linux how to solve it Using Outlook.com accounts in Outlook 0
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
S Activities in Outlook Outlook VBA and Custom Forms 3
S ios outlook Using Outlook.com accounts in Outlook 0
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Outlook - eliminate same adresses from to, and bc line Outlook VBA and Custom Forms 0
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
G Outlook Express (DBX) to Outlook (PST) Conversion Software Wanted Using Outlook 1
J Outlook 2016 Can't display some embedded HTML images in Outlook 2016 Using Outlook 2
J Outlook EAS protocol version Using Outlook 1
N Outlook 2021 'Run Script" Rules? Outlook VBA and Custom Forms 4
C Why does Outlook (desktop) 365 for Windows keep making me input my passwords? Using Outlook 8
P Comcast IMAP broken but their second level support said to call "the Outlook company" Using Outlook 4

Similar threads

Top