Listing filenames into a file with no access to the command prompt

[Marshmallowman]

Ok, I'll bite. what does mozilla thunderbird do/not do that stops you from using it.

[Jammrock]

Ok, I'll bite. what does mozilla thunderbird do/not do that stops you from using it.

Besides being buggy and not having a back-end to share calendars, email, etc.? The interface isn't as sleek and easy to use (believe it or not, MS did a pretty good job in O2k3). The features thunderchicken does have aren't very advanced as Outlook's, as MS has been making email clients longer than Mozilla, and has a gargantuan budget to develop it. Outlook isn't a perfect client, but it is the closest there is to a universally good - can do personal to enterprise emailing - email client there is.

...whether you hate MS or not, it's still the truth.

[Marshmallowman]

well the email sharing does work( i share emails from works exchange server) , but no calender

[Wombat]

Personally, I use Evolution. Interfaces (via the web protocol) with Exchange servers, too.

[GNEP]

Well the only things I don't really like about Outlook are

(a) .pst files (how big??? can they be imported into anything else??? Why do I need to delete AND compact to get them to remain managable??? Maybe this has improved since O2k)

(b) The fact I can't get a version for Linux Otherwise would seriously consider moving my home surfing/emailing machine over to one distro or another to have a bit of a play. Oh, and to be a bit more within the letter of the law.....

[Jammrock]

Well the only things I don't really like about Outlook are

(a) .pst files (how big??? can they be imported into anything else??? Why do I need to delete AND compact to get them to remain managable??? Maybe this has improved since O2k)

(b) The fact I can't get a version for Linux Otherwise would seriously consider moving my home surfing/emailing machine over to one distro or another to have a bit of a play. Oh, and to be a bit more within the letter of the law.....

PST/OST files (OSTs are the new PSTs in O2k3 and beyond) can be exported, and then re-imported. PST/OSTs are also jut databases, so it's not a stretch to import one. A simple Google search will yield several hits on tools to export/import PST files to other email systems, including Thunderchicken. And as a db they must be compacted/compressed. The new OSTs have size limits of 20 GB, as they are unicode.

As for (b), that's your own fault for using Linux

Jammrock

[Kooldino]

Man, I wish I still had Lotus Notes......

No really, you don't.

[Ali]

Its probably too late, but for future use, heres a little VBA for excel that I wrote a few years back that I use every now and again.

Just a quick look through. i is used for the row number, and this particular varsion uses a named range called fr.Source to give the base directory you want a list of names of. fr.Source is also used a a cheap way to get the column to dump filenames to.

I could email you the spreadsheet this is used in if you want. PM me if you want a look.

Also, I spent a lovely 3 months contracting for the NHS, and was astounded that they gave me full read/write access to the entire UK patient DB after being there for 3 days! I could change what drugs patients received, their addresses, history, etc etc. I never did of course, but it does make you wonder who else has access.

Public Sub LoadFilenames()
' PURPOSE:
'   Load a list of a specified folder into column A of the spreadsheet
'
' REQUIRES:
'   Reference to microsoft Scripting Runtime (must be registered)
'      (\Windows\system32\scrrun.dll)
'       regsvr32 c:\windows\system32\scrrun.dll

Dim fso As Scripting.FileSystemObject
Dim SourceFolder As Scripting.Folder
Dim FileItem As Scripting.file
Dim strFolder As String
Dim i As Integer

On Error GoTo Err_LoadFilenames
    i = 2
    Set fso = New Scripting.FileSystemObject
    strFolder = Range("fr.source").Value
    Set SourceFolder = fso.GetFolder(strFolder)

    For Each FileItem In SourceFolder.Files
        Debug.Print FileItem.Name
        Cells(i, Range("fr.Source").Column).Value = FileItem.Name
        i = i + 1
    Next FileItem
    
    Set FileItem = Nothing
    Set SourceFolder = Nothing
    

    Set fso = Nothing
    Exit Sub
    
Err_LoadFilenames:
    Select Case Err.Number
        Case 76 'Path not found
            MsgBox "Please make sure the Source path is correct", , Err.Description
        Case Else
            Debug.Print Err.Number & ": " & Err.Description
            Resume Next
    End Select
    
End Sub

[GNEP]

Cheers Ali. Problem solved via the batch file route, but I think I'll tuck this one away for future use - at some point I will have to make this reporting system usable by others, and so could make it easier using something like the above.

I know what you mean about them and data security - within a week I had access to all sorts of stuff that I really shouldn't if they knew what they were doing. Hence my comment about ID cards

[lowlifecat]

Well the only things I don't really like about Outlook are

(a) .pst files (how big??? can they be imported into anything else??? Why do I need to delete AND compact to get them to remain managable??? Maybe this has improved since O2k)

(b) The fact I can't get a version for Linux Otherwise would seriously consider moving my home surfing/emailing machine over to one distro or another to have a bit of a play. Oh, and to be a bit more within the letter of the law.....

* Read ahead to skip outlook lecture *
Outlook PST 102
a)
before 2k3, psts had a 2gig limit. they actually started going funny at around 1.6gigs. You needed to always delete and compact it 'cause it doesn't take that long to fill it up (depending on your work). When you deleted an email, it DOESN't delete from the pst although you cannot see the email anymore. Compacting will actually clear it out. I prefer archiving everything (it's automatic, programable and i only have to worry about creating a new archive pst every 2 gigs)

o2k3 still used psts but they now have a 20gig. I really don't recomend you go above 3 or 4 gigs. It's becomes more laboursome to fix the bigger files (read: time consuming).

If you've recently upgraded to outlook 2k3; your old 9x/2k format pst will NOT be upgraded. you should create a new pst file and then either: 1. make old pst a backup/archive or 2. import the old into the new.
b)
almost all your data in outlook can be exported to multiple kinds of format. having said that; most alternate email apps will ask if you wanna import from outlook while installing.
i believe some open source apps will let you import the data as well. I'd have to ask the lunix gurus at work to be sure.
class dismissed
* end of outlook lecture *

I prefer thunderbird mainly because i've done way more outlook related tech support than a person should have to do.

/emwo

[cjolley]

I use Outlook at work. (not really any choice)
But at home I use Outlook Express!

Why?
The messages rules have more options.
And I use a LOT of message rules.