Link Outlook data to Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shellie - 18 May 2006 19:47 GMT

Why don't all the fields link from Outlook to Access? For example, the Title
field in Access is empty and does not link to the Job Title field in Outlook?

My goal, use the convenience of Access for mail merges/mailings, etc. from
existing contact data in Outlook by linking the tables. The problem is that
not all data carry over into Access - like the Job Title?

Thanks!

Reply to this Message

mdavison - 18 May 2006 21:44 GMT

Shellie, you can do pretty quick and dirty mail merges directly from
Outlook, or from Word for letters, labels and envelopes, linking to your
Outlook contacts. It sounds like you are making things a little more
difficult than required.
From Outlook Contacts, do >Tools>Mail Merge... from Word, do

>Tools>Letters & Mailings>Mail Merge ....

> Why don't all the fields link from Outlook to Access? For example, the Title
> field in Access is empty and does not link to the Job Title field in Outlook?
[quoted text clipped - 4 lines]
>
> Thanks!

Reply to this Message

Shellie - 22 May 2006 21:01 GMT

I understand how to do merges. What i need are the additional functions
offered in Access. However, data does not transfer from Outlook to Access,
so back to my original question, why does data that resides in the Job Title
field of Outlook not transfer over into Access. When you link a table then
view the data in Access most of it is there, except for the Title field which
is empty? Makes no sense that all other data would transfer. Is there a way
to rename the Outlook field of Job Title to Title, then Access would read it?

Thanks, again...

> Shellie, you can do pretty quick and dirty mail merges directly from
> Outlook, or from Word for letters, labels and envelopes, linking to your
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message