Question Sending Data to create Outlook Contact

[hurst75]

Hi All,

My apologies if I have posted this in the wrong thread - please point me in the right direction if this is the case.

Background to my Question;

My potential clients fill in a form on my website which populates a Mysql DB. I use Access to connect/link to the Mysql DB and from each record I produce a quotation proposal. Simple enough.
Not surprisingly included in the record data are names, phone numbers, email details etc.
At present I have automated the quotation generation using access reports. I store all the contact data in Outlook along with a custom task file for each quote/job.

Question;

How do I automate the generation of an Outlook contact from the access DB without having to enter the data manually.
The ideal scenario would be to have a button on the form which, with one click takes the contact details in the record data and creates a contact in Outlook.

I have limited VB knowledge but am willing to have a go.

Any help would be greatly appreciated.

Kind regards.

 

[Trevor G]

As always there will be many different ways to tackle this, first though it would be useful to know which version of Access you are using, having said this though, take a look at this link to get a sample database which deals with the subject.

Helen Feddema is the Access Archon who writes columns for Woodys watch, plus much more.

Just scroll down the list until you find the Access to Outlook Section

http://www.helenfeddema.com/CodeSamples.htm