Outlook form fields to Access table

**Access 2000 code module to import data from Outlook.



I use Outlook folders as a simple database using custom Outlook forms. This is fine to maintain the information but I want to use MS Access reports to print the records. By default, Access can link to Outlook folders and treat it as a table but it doesn't recognise customised fields.

My customised forms use a mixture of standard (ie. 'Subject', 'StartDate') fields and customised fields. The application should be able to cope with both.

The Outlook folder is stored in a .pst file.


The application should do the following:

- Allow the use to browse to the Outlook folder.

- Create a new, empty table in Access.

- Import each record from the Outlook folder to the new Access table

- The fields in the Access table should resemble the type of Outlook fields. eg. the standard Outlook field 'Note' should be imported into an Access Memo field.

The structure of the Access table should match the active fields in the Outlook form. ie. if the Outlook form has a field called 'UserID' then a field should be created in Access with the same name.

Typically there are only 10-50 records in the Outlook folder.

I've included a zipped .pst file containing a folder with customised fields for testing.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Complete ownership and distribution copyrights to all work purchased.

## Platform

MS Access 2000.

Habilidades: PHP

Ver mais: table data structure, scope application form, pst file, access database module, access 2000 database, form fields, import access database php, form background, create file table access, outlook import pst, create access database reports, create simple access database, access create form, outlook module, create table using, pst outlook, access testing, import pst, create code access, recognise, access form record, import database access php, windows form application database, testing access database, use code access

Acerca do Empregador:
( 0 comentários ) United Kingdom

ID do Projeto: #2960018

2 freelancers estão ofertando em média $26 para este trabalho


See private message.

$25.5 USD in 7 dias
(0 Comentários)

See private message.

$25.5 USD in 7 dias
(3 Comentários)