Extracting user-defined details from a public folder

Status
Not open for further replies.
V

Vaughan Davies

New Member
Outlook version
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
 
Status
Not open for further replies.
< VBA Script (Ask to where to save send mail) | Open attached CSV, copy newdata and paste it to database CSV >
Similar threads
Thread starter Title 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
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
D Lifelong Windows user - new to Mac - Help!!! Using Outlook 3
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
W OL giving basic auth when logged in to Win as specific user Using Outlook 0
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Edit contact from email does not open the user defined contactform Using Outlook 3
Witzker Set Cursor & Focus from any field to the body of a user Contact form in OL 2019 Outlook VBA and Custom Forms 1
Witzker Place cursor at opening, a user defined OL contact form Outlook VBA and Custom Forms 3
ill13 Prepend the user's computer name to the subject. Outlook VBA and Custom Forms 1
J How to create a drop down user defined field that will appear on an inbox view Outlook VBA and Custom Forms 8
J VBA Cannot programmatically input or change Value for User Defined field Using Outlook 1
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
icacream Outlook 2016 “Enter your user name and password for the following server.” Using Outlook 5
N Item cannot be saved because it was modified by another user or window, and, Item could not be moved... Using Outlook 0
A How to stop user form from disapearing once mail window is closed? Outlook VBA and Custom Forms 0
H Information from user defined field into Excel Outlook VBA and Custom Forms 7
D Outlook 2010 Outlook in Windows 10 keeps asking for user name and password repeatedly Using Outlook 14
E Asking user to select multiple options in a list in an email Outlook VBA and Custom Forms 0
icacream Enter your user name and password for the following server. Using Outlook 4
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

Similar threads

Back
Top