AW: Kontakte aus Outlook auslesen und ändern
17.09.2012 16:54:33
firmus
Hi Bertram,
falls Du Export/Import noch nicht genutzt hast, hier die VBA Variante.
Option Explicit
Sub OL_Contacts_Update_TLD()
' getestet 16.sep 2012 mit Outlook 2007
Dim myAppl As Outlook.Application
Dim myNameSpace As Outlook.Namespace
Dim myContacts As Outlook.Items
Dim myitems As Outlook.Items
Dim myItem As Object
Dim tmpc1, tmpc2 As String
Set myAppl = CreateObject("Outlook.Application")
Set myNameSpace = Outlook.GetNamespace("MAPI")
Set myContacts = myNameSpace.GetDefaultFolder(olFolderContacts).Items
For Each myItem In myContacts
If (myItem.Class = olContact) Then
tmpc1 = UCase(myItem.CompanyName)
tmpc2 = UCase(myItem.Email1Address)
If InStr(1, tmpc1, "Testfirma") Then
tmpc1 = myItem.CompanyName
tmpc1 = Replace(tmpc1, "testfirma", "")
tmpc1 = Replace(tmpc1, "Testfirma", "")
tmpc1 = Replace(tmpc1, "TESTFIRMA", "")
myItem.CompanyName = tmpc1
myItem.Body = myItem.Body & " Firma updated " & today & " " & Now
myItem.Save
End If
If InStr(1, tmpc2, "Testfirma") Then
tmpc2 = myItem.Email1Address
tmpc2 = Replace(tmpc2, "testfirma", "")
tmpc2 = Replace(tmpc2, "Testfirma", "")
tmpc2 = Replace(tmpc2, "TESTFIRMA", "")
myItem.Email1Address = tmpc2
myItem.Body = myItem.Body & " emailadr updated " & today & " " & Now
myItem.Save
End If
End If
Next
End Sub
Referenz für Outlook in VBA setzen - nicht vergessen.
Gruss
Firmus