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
I Outlook for Mac 2019 using on desktop and laptop IMAP on both need help with folders Using Outlook 1
A Reminder duplication Outlook and Outlook.com Using Outlook.com accounts in Outlook 5
F Moving Outlook to new PC Using Outlook 0
mll persistently customise columns in outlook advanced search Using Outlook 3
Ken Pascoe Outlook Categories Quick List Using Outlook 0
M All fonts in Outlook emails display with exaggerated character spacing Using Outlook 1
talla Can't open Outlook Item. Using Outlook 0
C Can't Locate an Unread Message in my Outlook view pane Using Outlook 0
C Outlook 2007 Removing then adding account restores junk email processing Using Outlook 0
P Importing other e-mail accounts into Outlook Using Outlook 1
J Read Outlook Form fields Outlook VBA and Custom Forms 3
B Inconsistent handling of message read/unread status by Outlook Using Outlook 3
R Rogue Outlook Rule ? Using Outlook 2
S vba outlook search string with special characters Outlook VBA and Custom Forms 1
F Wishlist Outlook suddenly began synchronizing deleted items every time I delete a single email. Using Outlook 2

Similar threads

Top