![]() |
Write data into ContactItem field
After finding a contact item, is it possible to write data into another field
of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
Yes, that's it exactly.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "TS Lim" wrote: After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
Looks fine to me. Does it work for you?
You might want to check that myItem is not Nothing first. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "TS Lim" wrote in message ... After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
Dear Dmitry,
I tried to run it, but it does not work. TS Lim "Dmitry Streblechenko" wrote: Looks fine to me. Does it work for you? You might want to check that myItem is not Nothing first. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "TS Lim" wrote in message ... After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
After finding the item, I can read data of fields of the item. But to write
data, it still does not work. Any advise ? TS Lim "Sue Mosher [MVP-Outlook]" wrote: Yes, that's it exactly. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "TS Lim" wrote: After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
What specifically doesn't work? Error messages? Other symptoms? Does myItem
return the correct object? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "TS Lim" wrote: After finding the item, I can read data of fields of the item. But to write data, it still does not work. Any advise ? TS Lim "Sue Mosher [MVP-Outlook]" wrote: Yes, that's it exactly. "TS Lim" wrote: After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
When I run the sub procedure, no error message was prompted, and when
checking with my outlook folder, the Spouse field was not updated. I try to check by adding 2 msgbox as show below. When the procedure is run, Test 1 message box prompted, but Test 2 message box does not prompt. Looks like the procedure stop running at the line 'myItem.Spouse = "Mrs ID000001"' Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") Msgbox "Test 1 on whether procedure run until here" myItem.Spouse = "Mrs ID000001" Msgbox "Test 2 on wheterh procedure run until here" myItem.Save "Sue Mosher [MVP-Outlook]" wrote: What specifically doesn't work? Error messages? Other symptoms? Does myItem return the correct object? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "TS Lim" wrote: After finding the item, I can read data of fields of the item. But to write data, it still does not work. Any advise ? TS Lim "Sue Mosher [MVP-Outlook]" wrote: Yes, that's it exactly. "TS Lim" wrote: After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
Write data into ContactItem field
Dear Sue,
Pls ignore my reply earlier on your question below. It is working now. Thank you a lot for your prompt and precise reply. Regards, TS Lim "Sue Mosher [MVP-Outlook]" wrote: What specifically doesn't work? Error messages? Other symptoms? Does myItem return the correct object? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "TS Lim" wrote: After finding the item, I can read data of fields of the item. But to write data, it still does not work. Any advise ? TS Lim "Sue Mosher [MVP-Outlook]" wrote: Yes, that's it exactly. "TS Lim" wrote: After finding a contact item, is it possible to write data into another field of the item ? In the example below, after finding the item with the CustomerID field. It try to write data into the Spouse field. Is it the right way to do it ? It not, kindly advsie a way where I can write data into the fields of item selected. Dim myOlApp As New Outlook.Application Dim myNamespace As Outlook.NameSpace Dim myContacts As Outlook.Folder Dim myItem As Outlook.ContactItem Set myNamespace = myOlApp.GetNamespace("MAPI") Set myContacts = myNamespace.GetDefaultFolder(olFolderContacts) Set myItem = myContacts.Items.Find("[CustomerID] = ""ID0000001""") myItem.Spouse = "Mrs ID000001" myItem.Save Your advise is appreciated. Thank you. TS Lim |
All times are GMT +1. The time now is 04:11 AM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com