Access table Linked to Outlook contacts

[doco]

I want to link an Access 2000 table to my Outlook 2000 contacts list. How
does one eliminate all the extemporaneous fields from the link.

EG. I want name, address, city, state, zip, phone, fax, cell, email and
eliminate the other 35 fields?

TIA
doco

 

[Guest]

You can link directly to the outlook model by importing as a table.

Alternatively, through code, you can refer to any field in the contacts list.
You'll need to add a referecne to the object model (Outlook 10.0 or whatever
version you have).
This in the VBA editor, under TOOLS > REFERENCES

 

[doco]

So, code is the ONLY way to limit fields by link? Or update the table by
code when currentdb opens?

Either way, kewl!

thanks
doco

 

[Guest]

If you go into your tables area.
Click New and import or link a table.
Select EXCHANGE form the drop down in the dialog and a wizard will start.

In teh wizard, you select what you want to link to (contacts).
The second stage gives you the option of ignoring columns (fields)

 

[doco]

Well ther's the rub: if you select link - it just dumps the whole load.
There is NO opportunity to select fields. Now, with import table you have
opportunity to select fields. Except the field widths are so large as to be
near impossible to select in the wizard.

I have never worked with Outlook objects in VB|VBA before and the MSDN help
files well, are not much. do you know of a good online source?


Thanks
doco

 

[Guest]

There are loads of resources (not least of all here!)

You can check out www.functionx.com for online tutorials
There's also a great live forum at www.Experts-Exchange.com

Do you want to simply import the given fields into a table?

 

[Dirk Goldgar]

Well ther's the rub: if you select link - it just dumps the whole
load. There is NO opportunity to select fields. Now, with import
table you have opportunity to select fields. Except the field widths
are so large as to be near impossible to select in the wizard.

PMFJI, but is there a reason you don't want to link the whole table?
You can always create a query of the linked table to select only the
fields you want to deal with, and then work with that query. You can't
link a table and only link some of the fields.