Connecting Tech Pros Worldwide Help | Site Map

Problems with Form fields using Linked Outlook Contacts Table

sfriedman
Guest
 
Posts: n/a
#1: Nov 13 '05
I was able to successfully link my Outlook Contacts table to an Access
Database and create an entry form. Unfortunately the Displayname field
which is one of the key fields for how the contact is stored states
that it is an expression and will not accept entry, nor will it
automatically conjoin the first and last names as it would normally do
if you entered it in an outlook form. Without this when you click on
the entry in outlook instead of displaying the form, it launches a
blank email.
Also their appears no way that I can detect for mapping fields in
access to custom ones created in outlook except for 4 userdefined
fields.
I am the membership chairperson for a club and am resonsible for
tracking membership info and then sending out frequent annoucements by
email. I am tired of having to keep in synch my access database, my
outlook contact database, and my distribution lists. When I tried to
send emails from Access, the system would not allow it I assume because
it tried to send them too fast or something and the server rejected
them. Ideally I'd like to do it all from ACccess and create
distribution lists that would stay in synch with the master contacts
table. Any help on this would be greatly appreciated.

Dušan Vrban
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Problems with Form fields using Linked Outlook Contacts Table


On 12 Aug 2005 13:37:52 -0700, sfriedman wrote:
[color=blue]
> I was able to successfully link my Outlook Contacts table to an Access
> Database and create an entry form. Unfortunately the Displayname field
> which is one of the key fields for how the contact is stored states
> that it is an expression and will not accept entry, nor will it
> automatically conjoin the first and last names as it would normally do
> if you entered it in an outlook form. Without this when you click on
> the entry in outlook instead of displaying the form, it launches a
> blank email.
> Also their appears no way that I can detect for mapping fields in
> access to custom ones created in outlook except for 4 userdefined
> fields.
> I am the membership chairperson for a club and am resonsible for
> tracking membership info and then sending out frequent annoucements by
> email. I am tired of having to keep in synch my access database, my
> outlook contact database, and my distribution lists. When I tried to
> send emails from Access, the system would not allow it I assume because
> it tried to send them too fast or something and the server rejected
> them. Ideally I'd like to do it all from ACccess and create
> distribution lists that would stay in synch with the master contacts
> table. Any help on this would be greatly appreciated.[/color]

Hi,

i was trying that for sometime myself. Then after hours of trying i have
read some help on MS website and figured out that it can not be done in
anyway. There's some logical explanation to it which i forgot by now. You
can link ONLY for reading, you can not update. If you want to update, you
need to create (or buy somewhere) a synchronization tool.

I think it is better to consider solving that email sending problem?
Perhaps somebody with experience from asp can help. I think there are good
solutions.

If someone has a better idea, I would like to read it. :-)
pietlinden@hotmail.com
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Problems with Form fields using Linked Outlook Contacts Table


sounds like it's reformatting the field in the AfterUpdate of a field
or something, and since you're not entering the data through the
Outlook form, the event doesn't fire.

Closed Thread