Extracting user-defined details from a public folder

Status
Not open for further replies.

Vaughan Davies

New Member
Outlook version
Outlook 2007
Email Account
Exchange Server
Hi

A few years ago (with the help of Sue Mosher's book on Outlook Programming) I created a simple Outlook-based application for recording notes and actions relating to current projects. Users complete simple forms and these are saved to a public folder on our Exchange 2010 server. There are a number of user defined fields in the folder like "Project Number", "Customer" and "Complete (Y/N)".

Now I have been asked to produce a regular printed report drawing together these notes with other details from the company's ERP system. The report has to be printed because it will form part of the agenda for a regular Project Meeting with senior staff.

My initial idea was to link to the folder from Access using the provided Outlook link. I can get at the other data using SQL, it would simple be a matter of creating an Access report that provided all the information in the required format. However the Access to Outlook link does not return any user-defined fields.

I have done some Googling and discovered that the Exoledb provider was discontinued in Exchange 2010, and replaced by something else (WebDAV? or possibly EWA?). At any rate I'm now way out of my comfort zone.

So is there an obvious, easy way to get the data from the public folder into my report that I'm missing? Or if I have to learn to use one or both of these tools, or indeed something else, can anyone point me towards some basic instructions on using them?

TL;DR

How do I get Public Folder user-defined data into an Access table
 

Diane Poremsky

Senior Member
Outlook version
Outlook 2016 32 bit
Email Account
Office 365 Exchange
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
B Extracting email addresses from a folder - how to also get the name of the person the address is for? Using Outlook 5
O Extracting all mail addresses from all folders Using Outlook 10
M Extracting cell data from table Outlook VBA and Custom Forms 2
A Extracting only one recipient from Msgitem.To Outlook VBA and Custom Forms 7
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
M Oh please read---> Extracting email web leads on to excel spread sheet Using Outlook 3
J Need Help Extracting Email Content into Excel Specifically the Attachment Name Using Outlook 3
D Extracting Location info from All Day Event in mailboxes into webpage Exchange Server Administration 3
K Help with extracting data from a windows mobile device Using Outlook 5
E Extracting CC Email Address Using VBA Outlook VBA and Custom Forms 2
K Extracting Calendar information from a OST file? Exchange Server Administration 5
icacream Enter your user name and password for the following server. Using Outlook 5
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
S User Defined Fields adding new value (2) Using Outlook 0
R Creating a user defined function Outlook VBA and Custom Forms 3
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
M How to export Voting Results with user names and their responses Outlook VBA and Custom Forms 13
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
G <mailto:user@domain.com<mailto:user@domain.com<mailto:user@domain.com>>> Using Outlook 5
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
A Created a new user account and the local account cannot see email Using Outlook 3
N How to set automatically the default or user defined Quickstyle Templates by Answer in Outlook Using Outlook 1
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
Daniel Schunk User-defined form arrives empty at the recipient Using Outlook 3
C Changed By field not displaying individual user's name in O365 Shared Mailbox Using Outlook 9
M other user's mailbox won't open, forms disappeared Using Outlook 42
S Custom user fields in received messages Outlook VBA and Custom Forms 1
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 10
T Have Outlook 2016 suggest email address auto complete entries directly from the user's contacts list Using Outlook 0
Potty Ash MS Outlook 2010 custom form - validation or formula to request user to check a checkbox Outlook VBA and Custom Forms 16
P Change PC User Directory & iPhone Sync Using Outlook 2
J Assess content of User Defined Field in Rule Using Outlook 3
M How can I determine which user read an email Exchange Server Administration 4
J reinstalling Outlook 2007 asking for user name & password Using Outlook 14
R Prompt asking the user to send email to folder as *.msg file Outlook VBA and Custom Forms 1
J Outlook - 2013 - Error msg when copying folders from Online Archives to another user's mailbox Using Outlook 0
N Select a folder in a user account Outlook VBA and Custom Forms 2
S Outlook User defined date field (UDF) not syncing Using Outlook 2
A How to enable outlook room finder (outlook connector (mapi)) user ? Using Outlook 3
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3
B ActiveExplorer return NULL on new Window user login and running Outlook first time Using Outlook 1
S how to set user properties to a newly created appointment Outlook VBA and Custom Forms 12
S VBA with User Defined fields Outlook VBA and Custom Forms 9
D Unable to Send On Behalf of Another User Exchange Server Administration 0
M Exchange 2013 On premise set MessageRateLimit for User has no effect. Exchange Server Administration 0
A Block user to send emails to specific set of email ids Using Outlook 1
Similar threads


















































Top