Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Link Outlook data to Access (http://www.outlookbanter.com/outlook-using-contacts/15130-link-outlook-data-access.html)

Shellie May 18th 06 07:47 PM

Link Outlook data to Access
 
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!

mdavison May 18th 06 09:44 PM

Link Outlook data to Access
 
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 ToolsMail Merge... from Word, do
ToolsLetters & MailingsMail Merge ....



"Shellie" wrote in message
...
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!




Shellie May 22nd 06 09:01 PM

Link Outlook data to Access
 
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...

"mdavison" wrote:

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 ToolsMail Merge... from Word, do
ToolsLetters & MailingsMail Merge ....



"Shellie" wrote in message
...
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!






All times are GMT +1. The time now is 05:34 AM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com