Database Search

match allmatch any Look in all areasLook in current areas Check all datesPrevious dayPrevious 3 daysPrevious weekPrevious fortnightPrevious monthPrevious 2 monthsPrevious 3 monthsPrevious half-yearPrevious year

TechHome

Redemption

• 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.

Adding Contact Information into Outlook

 Keywords: contact information create add 

---

Question:

Does anyone have some code for adding contacts into the contact list in Outlook 2000? I have looked in Tech support, but can only find information regarding exporting data into XML format or an excel spreadsheet. I am looking to scan an excel spreadsheet containing updated contact information, and then check if contact exists, update it or if it does not exist, create it.

Answer:

You'll have to come up with your own code to search thru contacts to see if one is already there. But this should get you started.

olContactItem = 2
objOutlook = objectopen("Outlook.Application")

newContact = objOutlook.createItem(olContactItem)

;' Set some properties for the contact
newContact.FirstName = "Joe"
newContact.LastName = "Blow"
newContact.BusinessAddress = "One Microsoft Way"
newContact.BusinessAddressCity = "Redmond"
newContact.BusinessAddressState = "WA"
newContact.Email1Address = "JoeBlow@microsoft.com"
newContact.BusinessTelephoneNumber = "425-882-8080"
;   save it...
newContact.save

objectclose(newContact)
objectclose(objOutlook)

exit

---

Article ID:   W15612

File Created: 2003:05:13:11:29:14

Last Updated: 2003:05:13:11:29:14