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.
Similar threads
Thread starter Title 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
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
J Office 365 small business/Outlook 2013 issues Using Outlook.com accounts in Outlook 1
N How to install BCM for Outlook 2013 in Office 365 Small Business Premium BCM (Business Contact Manager) 1
R How to backup contacts in Outlook 2010 as business cards Using Outlook 1
X business owner in dire need of help outlook is not syncin my contacts! Using Outlook.com accounts in Outlook 2
D Shortcuts in Outlook Business Manager not wokring BCM (Business Contact Manager) 3
A Send a letter from Microsoft Outlook 2007 Business Contacts BCM (Business Contact Manager) 1
O BCM didn't install w small business outlook 2007 BCM (Business Contact Manager) 1
V I cannot open my outlook small business 2007 BCM (Business Contact Manager) 1
F Outlook 2010 Outlook 2010 and GMail Using Outlook 0
M Reverting The Outlook Search Box Location (or other undesired additions) Using Outlook 1
M Disable Contact Card Results when using "Search People" in Outlook Ribbon Using Outlook 4
P i-Phone 6s Plus receiving 2 notifications from Outlook email Using Outlook 1
C WARNING - DO NOT USE AN OUTLOOK.COM ADDRESS FOR GOOGLE ACCOUNT RECOVERY EMAIL Using Outlook 10
D Outlook 2016 Unable to load Outlook data pst file Using Outlook 5
M White square in body of Outlook Messages (O2016 Version 2012 32bit Click To Run) Using Outlook 4
M Outlook, send to > mail recipient - results in plain text email Using Outlook 1
R Why doesn't outlook use "Normal" style for new messages? Using Outlook 3
D Outlook 2016 Outlook not saving Sent Items Using Outlook 4
R How to Sync *all* Google Workspace Mail Folders with Outlook 2019 (MS365) Using Outlook 3
G Outlook 365 with iCloud account not syncing calendars Using Outlook 2
D Outlook 2016 Outlook Error Msg "The operation cannot be performed ..." How to Stop it Using Outlook 3
D Outlook.com premium finally dying... what do I do with my domain? Using Outlook.com accounts in Outlook 3
witzker Outlook 2019 is cutting Picture Extension *.pn_ Using Outlook 3
S Is there a free version of outlook? Using Outlook 0

Similar threads

Top