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
Travis Lloyd Messages Won't Display In Outlook 2019 Home & Business Using Outlook 0
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
kburrows Outlook 365 - Ribbon Customizations Disappear Using Outlook 0
D Wishlist How to use 'app password' in Outlook 2003 after Google pulled plug on "less secure apps" Using Outlook 1
L Restoring Outlook from backup pst file Using Outlook 1
e_a_g_l_e_p_i Kernel Outlook .pst viewer Using Outlook 3
L Outlook 365 Outlook not working on linux how to solve it Using Outlook.com accounts in Outlook 0
T Outlook 2019 Using Gmail aliases in Outlook Using Outlook 6
S Activities in Outlook Outlook VBA and Custom Forms 3
S ios outlook Using Outlook.com accounts in Outlook 0
W Transfer Outlook 2016 autocomplete file to Outlook 2007 Using Outlook 1
V iCloud calendar problems, Outlook shuts down immediately Using Outlook 2
S Outlook Macro for [Date][Subject] Using Outlook 1
E Outlook - Macro - send list of Tasks which are not finished Outlook VBA and Custom Forms 3
E Outlook - eliminate same adresses from to, and bc line Outlook VBA and Custom Forms 0
R How to force Outlook to use plain text in notes for Contacts? Using Outlook 1
G Outlook Express (DBX) to Outlook (PST) Conversion Software Wanted Using Outlook 1

Similar threads

Top