I have linked outlook conatcts to my db. I have a form that shows selected field from contacts (i.e. Business Details and contact details) which I want to add to :-
Business details to a table call tblClient
Contact Details to a table called tblCLientContact
The field names slightly differ between the Outlook link and my tables
I was looking for 2 buttons. 1 to add the client, 1 to add the contact.
Can anyone help?
For Information
Outlook
First, Last, Job Title, Phone, Mobile Phone, Email Address
To
tblClientContact
ClientContactID (Primary)
CC First Name
CC Last Name
CC Position
CC Tel
CC Mobile
CC email
And
Outlook
Company, Business Address Street, Business Address City, Business Address Postal Code, Business Fax, Web Page
To
tblClient
ClientID (primary)
Client Name
Client Address
Client Town
Client Postcode
Client fax
Client Website
I have had a look at the AddFromOutlook command but my db is split and I can find anywhere to specifiy vb code that actually maps the fields.