| 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. :-) |