Contacts

  • Thread starter Thread starter Leho
  • Start date Start date
L

Leho

Hello

This construction shows the values that I need:
MsgBox Excel.Workbooks(1).Sheets(1).Range("B" & i).Value

This construction shows the values that I need to update:
MsgBox TarkonFolder.Items(j).FirstName

But this construction does not update the field:
TarkonFolder.Items(j).FirstName = Excel.Workbooks(1).Sheets(1).Range("B"
& i).Value

I do not understand.
 
Leho said:
Hello

This construction shows the values that I need:
MsgBox Excel.Workbooks(1).Sheets(1).Range("B" & i).Value

This construction shows the values that I need to update:
MsgBox TarkonFolder.Items(j).FirstName

But this construction does not update the field:
TarkonFolder.Items(j).FirstName = Excel.Workbooks(1).Sheets(1).Range("B"
& i).Value

I do not understand.
Click to expand...

Can somebody please tell me how can I change my contacts properties.

It does not work this way:
Outlook.Application.GetNamespace("MAPI").Folders(1).Folders("Contacts").Folders("Tarkon").items(1).Firstname
= Leho
 
Is .Items(1) a contact item and not a DL item? You do need quotes
around a string when you set FirstName. Are you getting a valid folder
and Items collection? Any errors? Are you saving the item after you
change the FirstName?
 
Back
Top