Outlook User defined fields in Outlook 2007

[Latha]

Hi,

I have User defined fields in Task list(To-do list) which needs to be extracted to Excel.

But outlook allow users to extract only Pre-defined fields.

Could anyone help me in this regards?

do i need to run any macros for this?

If yes, please send the VB codes, if possible.

Thanks,
Latha

 

[Stoneboysteve]

Hi Latha,

This code is for an Outlook macro. You will need to enable macros to run it.

Here are some code snippets that will get you started:
Call and open an excel workbook:
Set oExcel1 = Item.Application.CreateObject("Excel.Application")
oExcel1.Visible = True
oExcel1.Workbooks.Open("C:\your file location and .xls")
Set oSheet3 = oExcel1.Workbooks(1).Worksheets("Sheet1")
oSheet3.Activate

Then you can either point scripted text to a named cell:
oSheet3.Range("B4").Value = "some text string"

Or you can point an Outlook value to a named cell"
oSheet3.Range("C5").Value = item.userproperties("YourCustomFieldName")

You can loop through folders in Outlook to include all items. You can create custom templates in Excel to receive your data.

Or you can do it the easy way and create a custom view in Outlook, include your custom fields, and copy paste into Excel.

You pick.

Stoneboysteve