Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
OLE and Outlook
 |
- Add Attachment to Journal Item
- Adding Contact Information into Outlook
- Compiled EXE Keeps Running Under Task Manager
- Copy Contacts Folder to Subfolder in Outlook
- Create a Folder under Personal Folders in Outlook
- Create Outlook Distribution List
- Creating Address Book XML File
- Current Contact Folder Items
- Delete Mail from Outlook using OLE
- Delete Outlook Contact
- Email Forwarder
- Embed an Image into an Outlook Email
- Empty Folder in Outlook
- Encrypt Message in Outlook
- Find Contacts in Outlook
- Find Folder with the String Mailbox
- Get Internet headers Field from Outlook Message
- Get Contact data form Contact Item Currently Selected in Outlook
- Get Contact Information In Outlook
- Get Internet headers Field from Outlook Message
- Get list of appointments
- Get member of Outlook Distribution List
- Get Outlook Contact information
- How to Send Mail from Outlook using OLE
- Identify Outlook Folder Type or Contents
- Import Excel Data into Outlook Contact Folder
- Launch Outlook and Make Visible
- List Subfolders
- Mark Messages as Read in Outlook using OLE
- ObjectEventAdd To Capture ItemSend Event
- OLE and OUTLOOK check mail
- OLE and OUTLOOK read mail other than inbox
- OLE and OUTLOOK read mail
- OLE MAPI Choose Folder
- OLE_Outlook- add Entry to Address book
- Outlook - Get Oldest Email Message
- Outlook constants
- Outlook Contacts to XML
- Outlook PST to MSG Export
- Outlook Quit Event
- Outlook Received Date
- Outlook Reply-To in OLE
- Outlook Sendmail OLE Example
- Outlook Version
- Read Open Active Outlook Message
- Recurse Outlook folders
- Redemption Causes WinBatch Studio to Crash
- Rename Personal Folder in Oulook
- Save file attachments in Outlook
- Save outlook attachments
- Send to Multiple Recipients
- Sort Email by Received Time
- TypeOf Equivalent
- Use Existing Instance Or Create a New One If Necessary
- Using OLE to resolve name in Outlook
- WinBatch and Redemption Issue
- Writing Appointments to Outlook
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Get Outlook Contact information
Keywords: OLE Outlook Contact
Question:
I am trying to find an efficent way of getting a contact record from MS Outlook. I need to use the contact phone number as a reference to find the required contact. I have had a look through the documentation available but cannot find much information on this sort of usage.In Outlook, as a VBA script it is posible to run the following script but this is not very easy to run from other applications outside Outlook and "Number To Find" needs to be a variable which seems difficult to acheive in VBA.
Sub FindContact()
Set myOlApp = CreateObject("Outlook.Application")
Set myNameSpace = myOlApp.GetNamespace("MAPI")
Set myContacts = myNameSpace.GetDefaultFolder(olFolderContacts)
Set myItem = myContacts.Items.Find("[BusinessTelephoneNumber] =
""Number to find Here"" ")
myItem.Display
End Sub
Can anyone think of an easier more portable way of getting an Outlook 97/2000 contact record displayed by using a telephone number as a reference to find the required contact?
Answer:
Seems like OLE should pretty much do it. See stuff like the OLE ADO CDO section under WinBatch in the Tech Support database area (http://techsupt.windowware.com). The following works with the current version of WinBatch:
olFolderContacts = 10 ;constant referencing the 'Contacts' folder
myOlApp = ObjectOpen("Outlook.Application")
myNameSpace = myOlApp.GetNamespace("MAPI")
myContacts = myNameSpace.GetDefaultFolder(olFolderContacts)
myItem = myContacts.Items
myFind = myItem.Find('[BusinessTelephoneNumber] = "(206) 937-9335" ')
myFind.Display
Article ID: W14918
File Created: 2001:11:08:12:40:58
Last Updated: 2001:11:08:12:40:58