VBA - add business contact to company contact

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

how can i add a business contact to an existing company contact with VBA?

e.g. I´d like to add the business contact "Mr. Meier" to the company contact
"Kisters Ltd." - and i want to do this with vba because i have about 4000
contacts to check and add to the right "company contact".

where can i find the onject catalog for MS BCM with all objects, properties,
methods,...?

Thank you for your help!

Franz
 
Look for a table in the database named EntityMappingTable

I suspect you need to set the Business Contact's ParentEntityEntryID to
the Account's EntryID. However, I recall running into trouble in the
past because in some cases similar columns hold a simple GUID and and
not an Outlook EntryID. You best bet is to create a database with one
Account with a child Business Contact and examine the contents of the
table.

I once wrote some C# to build an Outlook EntryID from an entity's GUID.
I can probably dig that out if you need to do that. I recall there were
some secret ingredients (numerical folder Ids, or something) that took
me a while to figure out.
 
I've been looking for this myself and I do not believe it exists. I've
written a few routines now and digging up the information by writing some
code, setting breakpoints and examining the locals window to try and figure
out properties. It takes a little bit of work but it can be figured out
eventually. The object model works the same but I think some things would
require SQL Queries to the database. I've been lucky not to require that
yet.
 
Back
Top