Inward and Outward mail MS Access database

[Alhakeem1977]

Hi Dears,

How can I get a sample database that can handle the inward and outward mail in our company?

Which can be used by a multi-users that the user will enter his/her mail details outward like:

Mail Date, Sent to, Method "by Hand" or "Courier Service", Contents and Priority.


Your earliest response would be highly appreciated.

 

[Ranman256]

for importing data, create a macro in Outlook to take the selected mail item to import the data in the body,or attachment into access.


for sending email , just make a query and send it via:
docmd.SendObject acSendQuery ,"qsMyQuery",acFormatXLS,sTo,,,sSubj,sBody

 

[Alhakeem1977]

Thanks Runman for your reply, I ment by mail the physical mail or courtier shipments "DHL" received or sent by our staff.
Instead of maintaining a physical Log registering the income and outgoing posts by hand or by courtier services.
Now we are suffering with the physical register, I would be grateful if I can get an Access database template which can handel this process.

Thanks in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk