Exchange/email experts?

[Ravage]

Interesting problem.

UKVAC posts pre-1999 (i.e. from xy-mans time) actually has a weird data structure. in outlook it shows as a recieved date as "none" (i.e. null) although the sent dat field is correct.

My import to the forums wont work unless this recieved field is filled and without forwarding them all (and losing the sent date!) does anyone either

a) know a way to update it

or

b) have emails from pre 1999 that they can put in a .pst and email to me?

Cheers

Rav

 

[Ravage]

Actually...

This might be possible using Outlook Macro/Visual Basic App (VBA).

In theory it could loop thru each email and set the date recieved to the date sent.

Unfortunately VB aint my thing.... Anyone able to perhaps look at this for me?

Cheers

Rav

 

[Macro]

I've never tried VBA, but I can program most other languages.

If you want me to have a look, let me know so I can grab the messages off of you.

 

[Ravage]

I've never tried VBA, but I can program most other languages.

If you want me to have a look, let me know so I can grab the messages off of you.

Good luck...

I've put a PST file with the posts in at www.ukvac.com/temp/oldVACs.pst (6mb)

See what you think.... Thought I'd cracked it this morning by exporting to Acess but no date fields at all go thru that way. Duh!

 

[Macro]

I get a 'page not found' error trying to grab the pst file.

 

[Ravage]

Ahh, IIS security.... try

http://www.ukvac.com/temp/oldVACs.rar (winrar archive)

 

[Macro]

Well, here is some code (it runs on selected messages) but it reveals another problem!

ReceivedTime is a read only property, so you cannot change it.

so, I'll have some more attempts to see what can be done elsewhere.

how are you importing the data ?

---

Sub test()

Set objOutlookApp = CreateObject("Outlook.Application")
Set objSelection = objOutlookApp.ActiveExplorer.Selection

For Each Item In objSelection

Item.ReceivedTime = Item.SentOn

Next
End Sub

 

[Ravage]

ReceivedTime is a read only property, so you cannot change it.

how are you importing the data ?

That sucks! Well, I basically have a program to import it from exchnage into SQL Server. Frankly I wonder if the data can be written out to a file somehow that can be sucked back into a spreadsheet, database etc.

The access export from outlook (and import into access) doesnt take any date fields whatsoever, *sigh*

Just in case you didnt realise I'm off to Swiss meet tomorrow lunch (13th) till the 18th....

Thanks for the help - that VBA took you no time

 

[Alpha1]

Dude to the PST file not being able to be downloaded, if you add the MIME extension as an allowed type in IIS it will work