email ... storage system DB (1 Viewer)

[GaryPanic]

Left this one a little vague..

If I explain what I kinda want (which may be too much )..
I want to file emails in and sent - in a folder per records

so record number 12345 will have a folder on the server "12345"

is there a way of
selecting the email and copying it from the inbox/sentbox into this folder (with all/any attachments) and to reference itself accordingly
example
email sent to Jsmith with the subject 12345

to be filed in folder 12345
subject 12345 (datestamp from the email when it was sent to show that it is different from any other email, that may have the same reference/subject)
the date stamp can be at the front of the "file" or the end

or am I pushing my luck...

 

[theDBguy]

Don't see why not. Are we talking about Outlook?

 

[The_Doc_Man]

First, a clarification is in order.

When you say "copy to a folder" ... Both Outlook and the Windows File System have folder objects. Which flavor of folder is your destination? If you choose "Windows folder" then what format will you want/need for the elements saved that way?

 

[bastanu]

Have a look at my free utility http://forestbyte.com/ms-access-utilities/fba-outlook-companion/ that can scan through Outlook folders and atach email messages to records. If I understand you right you want to take that further by saving a copy in a network folder using record id as the name. That is all possible, you will need to modify the code to usè mailitem.saveas method to save the email as a .msg file

https://docs.microsoft.com/vba/api/MailItem.SaveAs


Cheers,
Vlad[/URL]

 

[GaryPanic]

thanks for feed back
Outlook yes
copy email from out sent/inbox that have been selected and insert into network folder
(the logic behind this is that everyone can see the emails/trail per case -ie 12345 and all correspondance)
I will look at the free utility and digest

Cheers
G