Peter's Forum

Welcome to our forum. Feel free to post a message.

Peter's Forum
Start a New Topic 
Author
Comment
Outlook to Access

I am starting to make an access database up of all the contacts in microsoft outlook, but as you remember there are an awful lot of different fields,if I dont use all the fields when I have listed them all in the database that I am designing can I delete out all the ones that I will not use and have not used. Will it then only fill in the field names that are remaining.

Thanks Tina

Re: Outlook to Access

Tina,
Hope the following helps.


Outlook Contacts to Access Database

You can quickly copy or link to your Outlook contacts in an Access database, enabling you to work with your Outlook contacts in an Access database. Your Access data is kept up to date with changes to Outlook contacts, and vice versa, if you choose to link contacts to Access.

Open Access and start a new, blank database or open an existing database.
Do one of the following:
On the File menu, point to Get External Data, and then click Import.
On the File menu, point to Get External Data, and then click Link Tables.
Note If you link Outlook data to Access, any items updated in Outlook are automatically updated in Access.

In the Link or Import dialog box, in the Files of Type list, click Outlook. If you have more than one Outlook profile, you are prompted for which profile to use.

In the Import Exchange/Outlook Wizard, select the folder or address book that contains the contacts that you want, and then click Next.

Expand the top mailbox folder.

Select the folder that contains the contacts that you want to export.

When you complete the wizard, the Outlook data is placed into an Access table.

Follow the instructions on your screen.

Re: Re: Outlook to Access

Sorry, don't change the name & email address.

Pete