form to view *.msg stored in folder? (1 Viewer)

GaryPanic

Smoke me a Kipper,Skipper
Local time
Yesterday, 23:55
Joined
Nov 8, 2005
Messages
3,296
OK I store emails in folders ( network drive ) so
S drive then client then ref
so S\ client\ 12345
and I store outlook emails in these folders so
s\ client\12345\ quote.msg

is there a way of getting Access to
list *.msg files (this bit is easy) and then preview the outlook message -(without using outlook)

I had in mind
12345\ quote.msg
12345\ correspondance.msg
12345\order.msg

and a list that would only show those three "messages" and then beneath it - a quick preview showing say x amount of the message ? (possible whom its from/to )
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 14:55
Joined
May 7, 2009
Messages
19,169
something like this:
Code:
dim path as string, dim msg() as string
dim i as long, s as string
redim msg(5000)
path = "\\s\client\12345\"
s= dir$(path & "*.msg")
while len(s) <> 0
    i=i+1
    msg(i)=path & s
    s = Dir$
wend
redim preserve msg(i)
 

GaryPanic

Smoke me a Kipper,Skipper
Local time
Yesterday, 23:55
Joined
Nov 8, 2005
Messages
3,296
hmmm..I can get a form to list - thats the easy bit - its the previewing the message within the *msg without opening outlook thats thrown me
 
Last edited:

Users who are viewing this thread

Top Bottom