Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Updating Outlook Contacts from Access

Status
Not open for further replies.

Moss100

Technical User
Aug 10, 2004
586
GB
Hello,

I would like Outlook to filter my email so when I get an email from one of my contacts it puts it in a seperate folder.

I understand how to do this using rules.

I would however like to be able to update my contacts from my access database.

My initial idea was to create a linked table to Outlook Contacts. Easy enough.

My intention was to then delete all records in the Outlook Table and run an Access Append query which would create the up to date contacts.

So the link has worked fine, but if i try to add a record, I get an error saying I dont have the correct permissions.

Running the Access Append query also gives the same result.

Can someone help - is there a better way to do this / how would I alter permission?

The aim for me is to click a button, deleting the current contacts and then running the Append query to create the new contacts.

Thank you for any help - Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top