Maintain Outlook Contacts with Access 2007

Normally, updating your address book would involve e-mailing your contact
with the information you already know and asking them to send you updates if
necessary. These mails in turn can bounce, go unnoticed or land in spam boxes.
When you do get replies, would you have the time to go through each of them,
find out what's changed and then meticulously copy-paste them into the
relevant places in your contacts boxes? Definitely not. Well, atleast some of
these ponderous tasks have been made easier. The downside is, you need not one,
but two or three programs installed to make it work. We're using a combination
of Outlook (where our contact information is), Access and InfoPath from the Beta
of Office 2007 we reviewed last month.

First, make sure your contact information is your Outlook, since Access
cannot use other mail clients or contact managers in the same way. Now, fire up
Access and create a new database and save it to a known location like your home
directory. Next, use the External Data tab, and use the 'More' dropdown
under the Import section to click on the 'Outlook Folder' item. This will
open a wizard to select which Outlook Folder you want to link to and how to link
to it. At this point, select to create a linked table, the 'Contacts' folder
inside the Address Books>Outlook Address Book hierarchy and click on Finish.
Now, you can see and edit all your contact information from Outlook inside this
Access database. Since this is a linked table, updates in one location are
reflected in the other system as well.

Now to get the updates, right-click on the table 'Contacts' on the left
and select 'Collect and Update data via E-mail'. This will open a second
wizard. On the first screen, select the 'InfoPath' option only if you're
sure that all the people you're sending the request to will have the InfoPath
program installed on their PCs. Office 2007 can let users use InfoPath forms
using a new Forms Server product, but neither is this server available at this
time nor does this wizard provide you an option to host your forms on one.
Contrarily, we found that the HTML form generated does not work on some systems
(possibly due to IE's security settings). In the wizard, select the fields you
want the users to view/update. If you don't want them to update a particular
field (say your nickname for them), then you can check on the 'Read only'
option while that field is highlighted in the right-side box. Do remember to
select the 'E-mail address' option from the dropdown when asked for the
recipient address field in the database. Finally select the recipients
themselves and click on Finish. If you configured Outlook to not automatically
send messages, you will need to now open it and click on 'Send All'.

Once your recipients update the information, all they need to do is click on
Send (even through a web-based mail using a browser-if you used the HTML form
option). The mail will land in a special 'Access Data Collection Replies'
folder under your Inbox in your Outlook and the information there will be
automatically updated in your Access database and from there into your Outlook
contacts.

Ok, now if you have a Word file that you want to send out these people, it is
very easy to do that from within Access itself. Right-click again on the
Contacts table and this time select Export and select 'Merge it with Microsoft
Office Word' from the menu. Select one of the options to continue. This will
open the Word document of your choice where you can insert the Mail Merge fields
from Mailings>Insert Merge Field and send out the mail.

In subsequent parts of this series, we shall look at other interesting things
that you can do with Office 2007 and also show you how to enhance productivity
using the facilities it provides.