Hello all,

I have a macro vb6 where i go in 1 folder in Microsoft outlook and then, extract some information for all of them in an excel sheet.

Ex: msg.To / msg.Subject / msg.ReceivedTime etc...

But i need to pull the FROM Who also.

Is that possible?

I tried with: rng.Value = msg.From

But no result. I have a blank result

Thanks again for your help.


Code:
 'Copy field items in mail folder.

For Each itm In fld.Items

intColumnCounter = 1

Set msg = itm

intRowCounter = intRowCounter + 1

Set rng = wks.Cells(intRowCounter, intColumnCounter)

rng.Value = msg.From

intColumnCounter = intColumnCounter + 1

Set rng = wks.Cells(intRowCounter, intColumnCounter)

rng.Value = msg.To

intColumnCounter = intColumnCounter + 1

Set rng = wks.Cells(intRowCounter, intColumnCounter)

rng.Value = msg.Subject

intColumnCounter = intColumnCounter + 1

Set rng = wks.Cells(intRowCounter, intColumnCounter)

rng.Value = msg.SentOn

intColumnCounter = intColumnCounter + 1

Set rng = wks.Cells(intRowCounter, intColumnCounter)

rng.Value = msg.ReceivedTime


Next itm

Toggle HighlightingOpen in New WindowSelect All