[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

Issue an SQL query or similar, to Outlook database?

I need to search for and delete all contacts with a particular company name, from my Outlook address book. Can I issue a query to fish out these contacts?
1 Solution
Kevin CrossChief Technology OfficerCommented:

Typically, if needing to do Outlook automation, I would think VBA within Outlook or .NET using the Outlook library. However, if we are talking Outlook 2007 as an example, you can just go to Contacts, change to the By Company view, and click Delete key with the Company name you want highlighted. It will delete all contacts under that group once you confirm prompt to make sure you are aware of this bulk action.

If you really want to interact with this via SQL, then see if this project http://synccontacts.codeplex.com/ helps give you an example. It shows how to synchronize contacts via Outlook and SQL Server, so you could technically manage contacts via SQL scripts and then just push back to Outlook.

Hope that helps!

bobox00Author Commented:
Thanks! After changing the List view, I right-clicked and went to options. Then I was able to add the Modified column, sort by it and delete the contacts I needed to get rid of.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now