Count of email messages
hi, !
I see how it can be done but it's not something I want to invest any money in. Oh well!
one long (and "bizarre" ?) approach:
- make a copy of yur *.dbx file (i.e.) FileCopy "your.dbx", "your.txt" (just in case)
- open "your.txt" (it could be directly within excel)
- delete/erase/... any cell with (semi)formulae causing errors/phantom external links
{F5} special... formulas / error
- count the len of usedrange minus the len of substituting "Date: " (i.e.)
=sumproduct(len(a1:e12912)-len(substitute(a1:e12912,"Date: ","")))/6
Date is case-sensitive and it ends with colon & space
it worked for me (almost exactly) with one or two OE ng-boxes files ;)
hth,
hector.
|