linking projects and tasks data to access or excel

Status
Not open for further replies.
M

Memet78003

I would like to link BCM data to ACCESS and prepare more customised reports.

How can i reach BCM data from Access or Excel?
 
L

Luther Blissett

On Jul 3, 1:20 pm, Memet78003 <Memet78...
wrote:
> I would like to link BCM data to ACCESS and prepare more customised reports.
> How can i reach BCM data from Access or Excel?


BCM data is stored in a Sql Server database.

If you have permissions to access the data through Outlook/BCM, then

you have permission to access the database through other apps like

Excel and Access.

Check the BCM team blog, this newsgroup, or the BCM SDK, for examples

of how to do so. I know they've been discussed before, but I don't

have the URLs.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
P Run Time Error 91 when linking contact to task in VBA Outlook VBA and Custom Forms 1
Travis Lloyd Linking Outlook 2016 Desktop To POP3 Acc't On Android Phone Using Outlook.com accounts in Outlook 2
M Linking Excel Cell to Shared Contacts Outlook VBA and Custom Forms 7
B Can't expose sender email address when linking outlook to access Using Outlook 3
Andrew Hawkins Linking tasks Using Outlook 1
N linking an already sent/rec'd email to contact record like it did in 2000 Using Outlook 0
C Linking e-mails BCM (Business Contact Manager) 1
K Need help concerning emails linking to BCM. BCM (Business Contact Manager) 0
P Linking email responses to initial email sent Using Outlook 5
J Linking Contacts to a Message Where the Contact isn't an Addressee Using Outlook 1
J Custom Contacts: Linking button to website Using Outlook 4
M Custom Contact form queries (date control & contact/calender linking) Using Outlook 1
R Can't use "manage linking and tracking" BCM (Business Contact Manager) 10
K add an email to a business contact without linking/tracking sender BCM (Business Contact Manager) 0
K add an email to an account without linking and tracking the email address BCM (Business Contact Manager) 0
B Linking from Excel to public outlook 2010 calendar. Using Outlook 0
W Linking dropdown values Outlook VBA and Custom Forms 1
H Not all Email folders appearing in Manage E-mail Auto-linking BCM (Business Contact Manager) 1
G Linking Outlook to Access for Contacts in Access Outlook VBA and Custom Forms 3
S Sharing BCM contacts and linking items to records BCM (Business Contact Manager) 1
K Linking Information from Accounts to Business Contacts Manager BCM (Business Contact Manager) 1
L Linking a Business Contact to multiple Accounts? BCM (Business Contact Manager) 2
K Auto-linking emails by default shared DB BCM 2007 on SQL 2008 BCM (Business Contact Manager) 4
L Out of memory errors and Auto-linking hangs BCM (Business Contact Manager) 2
M Can I use BCM projects for this BCM (Business Contact Manager) 1
T Business Projects question BCM (Business Contact Manager) 0
E No projects appearing in 'business projects' for bcm Using Outlook 0
J How do you manage "mini-projects?" Using Outlook 4
P Using BCM2010 Business Projects as SharePoint 2007 Data Source BCM (Business Contact Manager) 3
P Company name in Business Projects BCM (Business Contact Manager) 2
S Sharing BCM contacts within Workgroup, Leads and Projects BCM (Business Contact Manager) 5
C All my projects and project tasks are gone - OL BCM 2007 BCM (Business Contact Manager) 2
C I cannot open business projects but I can view them BCM (Business Contact Manager) 2
C RE: Can I make a template for Projects? BCM (Business Contact Manager) 2
L Format Lost between Tasks and To Do Using Outlook 0
S Outlook 365 Help me create a Macro to make some received emails into tasks? Outlook VBA and Custom Forms 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
V Backup Calendar, Contacts, Tasks in an POP3 data file Using Outlook 3
V Outlook 2016 iCloud for Windows - Why no working Calendars and Tasks ? Using Outlook 1
T Outlook 365 Move newly created tasks automatically on save. Outlook VBA and Custom Forms 1
Z Import Tasks from Access Using VBA including User Defined Fields Outlook VBA and Custom Forms 0
P Outlook tasks keeps changing (updating) dates that I type Using Outlook 2
kburrows Reset Date to Keep Tasks from Archiving Using Outlook 9
O Moving "tasks" to inbox in Outlook 2016 Using Outlook 1
O Tasks - how to display "snoozed" tasks and snooze-times? Using Outlook 7
T Outlook 2010 Tasks are not visible in To Do list Using Outlook 6
T Outlook creating unwanted tasks in Tasks and Todo from emails Using Outlook 1
S Copy Tasks/Reminders from Shared Mailbox to Personal Tasks/Reminders Outlook VBA and Custom Forms 0
S Outlook 2016 Arrange tasks by date, additional custom sorting, but still use friendly terms like Today, Tomorrow, This week? Using Outlook 1
V Outlook 2016 Multiple recurring tasks getting created Using Outlook 0

Similar threads

Top