Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Adding Entry to Outlook Address Book

Posted on 2000-04-12
2
Medium Priority
?
239 Views
Last Modified: 2010-05-02
I'm trying to add an address entry to the outlook address book.  I found this code in another section but can't get it to work even after adding MAPI components and referencing outlook.

Here's the code:
Function AddEntry()
 
Dim objSession As MAPI.Session   ' Session object
Dim objMyPAB As AddressList      ' personal address book object
Dim objNewEntry As AddressEntry  ' new address entry object
Dim propTag As Long              ' MAPI property tag for new field
 
On Error GoTo error_olemsg
Set objSession = CreateObject("MAPI.Session")
 
' log on to session, supplying username and password
objSession.Logon 'profileName:="MyProfile", _

                 'profilePassword:="my_password"
 
' get PAB AddressList from AddressLists collection of Session
Set objMyPAB = objSession.AddressLists("Personal Address Book")
If objMyPAB Is Nothing Then
    MsgBox "Invalid PAB from session"
    Exit Function
End If
 
' add new AddressEntry to AddressEntries collection of AddressList
Set objNewEntry = objMyPAB.AddressEntries.Add "SMTP", "Jane Doe"
objNewEntry.address = "janed@exchange.microsoft.com"

 
' set MAPI property in new AddressEntry (don’t need to Add it)
propTag = &H3A08001E ' VB4.0: ActMsgPR_BUSINESS_TELEPHONE_NUMBER
objNewEntry.Fields(propTag) = “+1-206-555-9901”
 
' add custom property to new AddressEntry and set its value
objNewEntry.Fields.Add “CellularPhone”, vbString
objNewEntry.Fields(“CellularPhone”) = “+1-206-555-9902”
 
' commit new entry, properties, fields, and values to PAB AddressList
objNewEntry.Update
MsgBox “New address book entry successfully added”

Exit Function
 
error_olemsg:
MsgBox "Error " & Str(Err) & ": " & Error$(Err)
Exit Function ' so many steps to succeed; just exit on error
 
End Function




I've put it all in a module and call the procedure - I keep getting this error: user defined type not defined ... on this line....

dim objSession As MAPI.Session
0
Comment
Question by:basica
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 28

Expert Comment

by:AzraSound
ID: 2709065
perhaps this code will give you some ideas
0
 
LVL 28

Accepted Solution

by:
AzraSound earned 60 total points
ID: 2709067
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question