Why doesn't an Access/Outlook link give me all my Outlook fields?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created new fields in Outlook that are not showing up when I like to a new
Access table. Only the original Outlook fields are showing up in Access. How
do I get all my data to link?
 
Erin said:
I created new fields in Outlook that are not showing up when I like
to a new Access table. Only the original Outlook fields are showing
up in Access. How do I get all my data to link?
Click to expand...

AFAIK you can't. I strictly use Outlook automation when I want to interact
with Outlook data. If you examine your link again you'll find that you're
not even getting all of the built in fields much less your custom ones. The
data structures used in Outllok are bizarre to say the least and are very
non-relational. I assume that this presents some inherant difficulties in
linking to them.
 
Erin,
Have you checked folder view properties in outlook?
Go to view/arrangeby/current view/customise view/fields.
The fields visible in outlook preview pane should be availble to access.

regards,
Mike Penrose
 
Tekkyun said:
Erin,
Have you checked folder view properties in outlook?
Go to view/arrangeby/current view/customise view/fields.
The fields visible in outlook preview pane should be availble to
access.

regards,
Mike Penrose
Click to expand...

Not only will you not get your custom fields but you aren't even getting all
of the built in ones. This is the way linking to Outlook has always been.
I assume it is because the internal storage structures in Outlook only
vaguely resemble "tables" so there are limitations on what Access can link
to.

With VBA code you can automate Outlook and get at all of the data (including
custom fields), but you cannot do this with a simple link.
 
Dear Erin Esq,

There's a good way to do this :
make another table that contains the other fields that you'd like to link to
the "Inbox table",the other table should contain the field "receiving date"
then make a relationship between "received" in the "inbox table" and
"receiving date"
Make a form that has its rowsource from the "Inbox" table and adda subform
that has its source from the other table that contains the fields that you'd
like to link to the "inbox". try to avoid mouse wheel in the subform as it
may confuse data ,you can avoid this by doing the following :
make unbound text boxes on the main form that has its value from the subform
example :
to view the value of the [customer code] form the subform on the main form
,you should make an unbound text box on the main form and type the following
code in the controlsource:
=[Forms]![Inbox]![othertable]![Form].[customer code]
once you do this for all the other fields you should set the value visible
of the subform to 'no'.
try it it's magnificent
 
Pietro - are you trying to tell us that IS it possible to keep Access &
Outlook synchronized? If I follow your instructions & If I set up my Access
table correctly? What about a query? Because, I have not started my project
yet & am trying to figure out the best way to keep everyting up to date -
and some of my contacts will not be in Outlook, I figure a query would be the
best way to accomplish that. But any help is useful. I have also posted a
question with Subject: merge Word & Access & Outlook. I am looking forward
to all help!

Pietro said:
Dear Erin Esq,

There's a good way to do this :
make another table that contains the other fields that you'd like to link to
the "Inbox table",the other table should contain the field "receiving date"
then make a relationship between "received" in the "inbox table" and
"receiving date"
Make a form that has its rowsource from the "Inbox" table and adda subform
that has its source from the other table that contains the fields that you'd
like to link to the "inbox". try to avoid mouse wheel in the subform as it
may confuse data ,you can avoid this by doing the following :
make unbound text boxes on the main form that has its value from the subform
example :
to view the value of the [customer code] form the subform on the main form
,you should make an unbound text box on the main form and type the following
code in the controlsource:
=[Forms]![Inbox]![othertable]![Form].[customer code]
once you do this for all the other fields you should set the value visible
of the subform to 'no'.
try it it's magnificent




Erin Esq. said:
I created new fields in Outlook that are not showing up when I like to a new
Access table. Only the original Outlook fields are showing up in Access. How
do I get all my data to link?
Click to expand...
Click to expand...
 
Hi Caryl..
I confirm that you can link your outlook inbox to access datbase and make
the fields you need add beside the ones of the outlook.,but there'a another
way more secure to use (i have been using this way to run my project for more
than 3 months)
First link the inbox of Outlook to your access database,then create a new
table that contains the exact fields of table 1 ,then add the fields you need
to add,then make a "Not maching query" ,there's a wizard to do this,that
links between the two tables,use the join type property to view the fields in
table1 that are not existent in table2(the one simliar to table1),you can use
the field "Received" to make the relationship between the two tables..
Finally make an append query that appends the not matching query fields
to table2,by doing this you need to make a button on your form to run the
append query,so at the end you'll make the required project successfully.

Caryl said:
Pietro - are you trying to tell us that IS it possible to keep Access &
Outlook synchronized? If I follow your instructions & If I set up my Access
table correctly? What about a query? Because, I have not started my project
yet & am trying to figure out the best way to keep everyting up to date -
and some of my contacts will not be in Outlook, I figure a query would be the
best way to accomplish that. But any help is useful. I have also posted a
question with Subject: merge Word & Access & Outlook. I am looking forward
to all help!

Pietro said:
Dear Erin Esq,

There's a good way to do this :
make another table that contains the other fields that you'd like to link to
the "Inbox table",the other table should contain the field "receiving date"
then make a relationship between "received" in the "inbox table" and
"receiving date"
Make a form that has its rowsource from the "Inbox" table and adda subform
that has its source from the other table that contains the fields that you'd
like to link to the "inbox". try to avoid mouse wheel in the subform as it
may confuse data ,you can avoid this by doing the following :
make unbound text boxes on the main form that has its value from the subform
example :
to view the value of the [customer code] form the subform on the main form
,you should make an unbound text box on the main form and type the following
code in the controlsource:
=[Forms]![Inbox]![othertable]![Form].[customer code]
once you do this for all the other fields you should set the value visible
of the subform to 'no'.
try it it's magnificent




Erin Esq. said:
I created new fields in Outlook that are not showing up when I like to a new
Access table. Only the original Outlook fields are showing up in Access. How
do I get all my data to link?
Click to expand...
Click to expand...
Click to expand...
 
Pietro - I want to be sure that I'm not confused or misunderstood. Your
reply mentions the "outlook inbox". What I want to link/sync is the contact
info. I currently have an access database with names, addresses & phone #'s.
I want to be able to make a change in Outlook & have Access be updated at
the same time. or vise versa. Still possible?
 
Hello Pietro,

Thanks for the fantastic idea below.
I have just completed an outlook-access link, but I appended my outlook
contats to my access table, then updated the "telex" field in the oultook
link table (which nobody ever uses) to contain my access table's autonumbered
ID field - works a treat!

Since you seem like such an expert on the topic I was hoping you might be
able to provide some further info regarding another issue I am having with
this link. Any outlook contatcs that do not contain a valid email address
are not included in the link table. I have tried entering some unique text
into the "display as" field since this seems to be used as the primary key,
but they do not appear in the link table until a valid email address is
inserted.

Any ideas?

Thanks heaps
Meg


Pietro said:
Dear Erin Esq,

There's a good way to do this :
make another table that contains the other fields that you'd like to link to
the "Inbox table",the other table should contain the field "receiving date"
then make a relationship between "received" in the "inbox table" and
"receiving date"
Make a form that has its rowsource from the "Inbox" table and adda subform
that has its source from the other table that contains the fields that you'd
like to link to the "inbox". try to avoid mouse wheel in the subform as it
may confuse data ,you can avoid this by doing the following :
make unbound text boxes on the main form that has its value from the subform
example :
to view the value of the [customer code] form the subform on the main form
,you should make an unbound text box on the main form and type the following
code in the controlsource:
=[Forms]![Inbox]![othertable]![Form].[customer code]
once you do this for all the other fields you should set the value visible
of the subform to 'no'.
try it it's magnificent




Erin Esq. said:
I created new fields in Outlook that are not showing up when I like to a new
Access table. Only the original Outlook fields are showing up in Access. How
do I get all my data to link?
Click to expand...
Click to expand...
 
I did not get you well....

Meg Russell said:
Hello Pietro,

Thanks for the fantastic idea below.
I have just completed an outlook-access link, but I appended my outlook
contats to my access table, then updated the "telex" field in the oultook
link table (which nobody ever uses) to contain my access table's autonumbered
ID field - works a treat!

Since you seem like such an expert on the topic I was hoping you might be
able to provide some further info regarding another issue I am having with
this link. Any outlook contatcs that do not contain a valid email address
are not included in the link table. I have tried entering some unique text
into the "display as" field since this seems to be used as the primary key,
but they do not appear in the link table until a valid email address is
inserted.

Any ideas?

Thanks heaps
Meg


Pietro said:
Dear Erin Esq,

There's a good way to do this :
make another table that contains the other fields that you'd like to link to
the "Inbox table",the other table should contain the field "receiving date"
then make a relationship between "received" in the "inbox table" and
"receiving date"
Make a form that has its rowsource from the "Inbox" table and adda subform
that has its source from the other table that contains the fields that you'd
like to link to the "inbox". try to avoid mouse wheel in the subform as it
may confuse data ,you can avoid this by doing the following :
make unbound text boxes on the main form that has its value from the subform
example :
to view the value of the [customer code] form the subform on the main form
,you should make an unbound text box on the main form and type the following
code in the controlsource:
=[Forms]![Inbox]![othertable]![Form].[customer code]
once you do this for all the other fields you should set the value visible
of the subform to 'no'.
try it it's magnificent




Erin Esq. said:
I created new fields in Outlook that are not showing up when I like to a new
Access table. Only the original Outlook fields are showing up in Access. How
do I get all my data to link?
Click to expand...
Click to expand...
Click to expand...
 
With Outlook 2007 and all prior Outlook versions, I can import an Access 2003
table into my Outlook contacts, but Outlook 2007 fails to list Access 2007 as
an import option; therefore I must maintain my Access database in 2003
format. I suspect there is a way to sync Outlook 2007 contacts with an Access
2007 format table, but I can't figure it out from your suggestion. Do I first
open Access 2007 then import Outlook Contacts? Please advise--I'm old, blond
and technically challanged.

Pietro said:
Hi Caryl..
I confirm that you can link your outlook inbox to access datbase and make
the fields you need add beside the ones of the outlook.,but there'a another
way more secure to use (i have been using this way to run my project for more
than 3 months)
First link the inbox of Outlook to your access database,then create a new
table that contains the exact fields of table 1 ,then add the fields you need
to add,then make a "Not maching query" ,there's a wizard to do this,that
links between the two tables,use the join type property to view the fields in
table1 that are not existent in table2(the one simliar to table1),you can use
the field "Received" to make the relationship between the two tables..
Finally make an append query that appends the not matching query fields
to table2,by doing this you need to make a button on your form to run the
append query,so at the end you'll make the required project successfully.

Caryl said:
Pietro - are you trying to tell us that IS it possible to keep Access &
Outlook synchronized? If I follow your instructions & If I set up my Access
table correctly? What about a query? Because, I have not started my project
yet & am trying to figure out the best way to keep everyting up to date -
and some of my contacts will not be in Outlook, I figure a query would be the
best way to accomplish that. But any help is useful. I have also posted a
question with Subject: merge Word & Access & Outlook. I am looking forward
to all help!

Pietro said:
Dear Erin Esq,

There's a good way to do this :
make another table that contains the other fields that you'd like to link to
the "Inbox table",the other table should contain the field "receiving date"
then make a relationship between "received" in the "inbox table" and
"receiving date"
Make a form that has its rowsource from the "Inbox" table and adda subform
that has its source from the other table that contains the fields that you'd
like to link to the "inbox". try to avoid mouse wheel in the subform as it
may confuse data ,you can avoid this by doing the following :
make unbound text boxes on the main form that has its value from the subform
example :
to view the value of the [customer code] form the subform on the main form
,you should make an unbound text box on the main form and type the following
code in the controlsource:
=[Forms]![Inbox]![othertable]![Form].[customer code]
once you do this for all the other fields you should set the value visible
of the subform to 'no'.
try it it's magnificent




:

I created new fields in Outlook that are not showing up when I like to a new
Access table. Only the original Outlook fields are showing up in Access. How
do I get all my data to link?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top