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?

Status
Not open for further replies.

Boxster

New Member
Outlook version
Outlook 2010 64 bit
Email Account
POP3
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
in Outlook BCM ?

Hi I am using Outlook, Business Contact Manager, and Excel all Ver 2010,
I have a SQL connection in Excel to Contacts Full View of BCM. It appears the none of the views includes any
User Defined Fields created in BCM.
In order to sync my UDF fields I have to have the
UDF I have created (A), and have found a BCM field that I was not using placed in the contacts view (B) in order to sync the data to Excel and still be able to use the Bulk Edit function in BCM.
My problem is that I have to copy the data in A across to B for each contact so that it is synced via SQL connection.

Is there a way to have a macro copy from A to B when data is entered?

I know there is a way to set up a query for the UDF's but I haven't been able to work out how it all works.

I would really appreciate any help or suggestions/solutions. Thanks
 
Status
Not open for further replies.
Thread starter Similar threads Forum Replies Date
M Queries on Business Contact Manager (BCM) with Outlook 2013 Using Outlook 1
V Custom UI Runtime Error in Business Contact Manager for Outlook (2013) BCM (Business Contact Manager) 6
J Business Contact Manager in MS Outlook 2010 - get error message when try to use. Using Outlook 2
C Sharing of a database in business contact manager in outlook 2007 Using Outlook 1
B synchronizing categories of contacts between outlook 2010 and business contact manager Using Outlook 1
T I cant find outlook business contact manager Using Outlook 6
B Outlook 2007 Business Contact Mgr and Word 2010 Using Outlook 1
B Restoring Business Contact Manager Database for Outlook 2007 Using Outlook 2
B Unable to install Business Contact Manager for Outlook Professional Plus 2010 on WIN 7 - 64bit Using Outlook 1
T Installation help for Outlook 2007 with Business Contact Manager Using Outlook 2
P Outlook 2010 stops working and closes when importing data to Business Contact Manager Using Outlook 1
D Outlook 2007 Business contact manager freezes up in office word Using Outlook 2
N Business Application for Master Category List in 2010 Outlook's Business Contact Manager Using Outlook 1
R Re: Business Contact Manager for Outlook 2010 Using Outlook 1
H How to restore the Master Category List in Outlook 2010 and Business Contact Manager 2010 on Windows Using Outlook 2
M Business Contact Manager (Outlook 2010) indexes Accounts but not Business Contacts Using Outlook 1
L Cannot open Outlook due to error message regarding Business contact manager Using Outlook 1
I Outlook 2010 Shutting Down When Trying to Import Contacts to Business Contact Manager Using Outlook 3
F Import Outlook and Business Contact Manager data to another user Using Outlook 3
D Moving from Business Contact Manager for Outlook 2007 to BCM 2010 Using Outlook 1
F Business Contact Manager for Outlook cannot complete your last action or actions. Please try again. Using Outlook 3
G Daily Activities Report in MS Outlook 2010 Business Contact Manager Using Outlook 1
R Availability of Business Contact Manager for Outlook 2010 Using Outlook 2
H Outlook 2007 Business Contact Manager Using Outlook 5
M Enable to access outlook 2003 even in safe mode and is giving an error message that Business Contact Manager has encountered a problem Using Outlook 2
N Outlook 2007 -- Not responding when switching to Tasks, To Do lists // Business Contact Manager? Using Outlook 4
S Business Contact Manager (BCM) causing Outlook crash loop BCM (Business Contact Manager) 3
D business contact manager did not install with outlook 7 BCM (Business Contact Manager) 2
C "Business Contact Manager for Outlook could not connect to db BCM (Business Contact Manager) 1
J outlook 2003 business contact manager BCM (Business Contact Manager) 1
C Outlook Business Contact Manager Beta Not Working BCM (Business Contact Manager) 2
M Is Business Contact Manager gone in Outlook 2010? Outlook VBA and Custom Forms 2
N Outlook categories for Business contact manager BCM (Business Contact Manager) 2
R Outlook 2007 w/ Business Contact Manager compatible w/ Cardscan? BCM (Business Contact Manager) 1
B How to remove user from business contact manager for outlook 2007database tool(BCM) BCM (Business Contact Manager) 2
D Business Contact Manager for Outlook Problem BCM (Business Contact Manager) 1
R How do I turn off the Business Contact Manager startup in Outlook BCM (Business Contact Manager) 1
M Business contact manager 2003 on outlook 2007 BCM (Business Contact Manager) 1
J outlook fails to start then problem with business contact manager BCM (Business Contact Manager) 1
J how to add Business Contact Manager to existing Outlook 2007? BCM (Business Contact Manager) 2
M How do I install Outlook 2007 Business Contact Manager on Win7x64 BCM (Business Contact Manager) 1
B RE: Why does Business Office Contact Manager shut down Outlook? BCM (Business Contact Manager) 3
M 2007 Outlook - no Business Contact Manager BCM (Business Contact Manager) 7
P Setup failed to install Business Contact Manager for Outlook 2007 BCM (Business Contact Manager) 2
C Business Contact Manager and Outlook 2007 "not enough free memory BCM (Business Contact Manager) 5
B Importing business card into Outlook for SIgnature Using Outlook 1
M Adding fields to Task in Outlook Home and Business 2010 Outlook VBA and Custom Forms 7
D screwy behavior Business Card - Outlook 2013 Using Outlook 8
stephenjones Adding a business account to Outlook Using Outlook 1
S Can't send messages using Outlook 2007 from a business email Using Outlook 3
Similar threads


















































Top