Read data from outlook custom form and export it to MS SQL Server DB

[Ilin Start via OfficeKB.com]

Please help. I am new to outlook programming. I need to read data from custom
outlook form and export it to MS SQL server DB? Any code examples or
suggestions will be greatly appreciated.
Is it possible to achieve this task using ActiveX script in MS SQL DTS
package? Any other solutions?

Regards,
Ilin

 

[John Riddle]

I'm assuming that you mean reading "custom fields" in an Outlook Item. Data
isn't stored in the form, it's stored in the Outlook (or Exchange) item.

The following code assumes that you have set "myItem" to equal an actual
Outlook Item.


For Each oProp In myItem.ItemProperties
On Error Resume Next
'view the data in a message box (you could put other code to do
whatever else you want with the data)
MsgBox myItem.ItemProperties(oProp)
Next

For Each oProp in myItem.UserProperties
'view the data in a message box (you could put other code to do
whatever else you want with the data)
MsgBox myItem.UserProperties(oProp)
Next

Note: if you're using .NET you'll have to use
"myItem.UserProperties(oProp).Value"

John

Please help. I am new to outlook programming. I need to read data from custom
outlook form and export it to MS SQL server DB? Any code examples or
suggestions will be greatly appreciated.
Is it possible to achieve this task using ActiveX script in MS SQL DTS
package? Any other solutions?

Regards,
Ilin

 

[Guest]

Maybe this can help:
http://www.geniusatwork.nl/articles/Products/2/3/