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
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
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
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
N Re: Outlook 2003 Business Edition Using Outlook 2
F Custom permissions using SQL 2008 Enterprise with Business Cotact Manager for Outlook 2010 Using Outlook 1
D 2007 Outlook no longer connecting with AOL account. Help, small business! Using Outlook 1
A I have purchased a replacement computer and installed Outlook 2010. My server is a 2003 small business exchange server. How can I access the calenda Using Outlook 1
J missing permissions feature in Outlook 2010 (Home and Business) 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
witzker print-list-of-outlook-folders with sort posibility Outlook VBA and Custom Forms 3
witzker Open Contact missing in Outlook 2019 Using Outlook 2
D.Moore VB script to Digitaly Sign newly created outlook message Outlook VBA and Custom Forms 2
B Outlook 2016 Retail C2R keeps logging since update? Using Outlook 0
M outlook 365 trying to finish my sentences Using Outlook 0
D Outlook Address Book Using Outlook 0
B Emails get stuck in Outbox of Gmail IMAP in Outlook for Windows Using Outlook 0

Similar threads

Top