Sending information from database over email at end of day

[Sandretto]

I've created a database for orders on microsoft Access, the company is now splitting into 2 locations, 1 for production the other for accounts/admin. Ideally the delivery details need to be sent to accounts on daily basis, instead of individually typing an email was wondering is it possible to automate a system? All information is in 1 table called deliveries. For example sending delivery details from that day.

Thanks in advance for your help!

[jimatqsi]

Yes, you sure can send emails from Access. Here's two threads I posted on recently, and I'm sure there are many others here.

Good luck and be sure to let us know if you have any trouble getting that going.

Jim

http://bytes.com/topic/access/answers/890721-how-use-vba-add-attachments-emails

http://bytes.com/topic/access/answers/890885-problem-emailing-access

[Sandretto]

Thanks I'll have a look, do you have to use outlook?

[jimatqsi]

No, not if you use CDO, in that case Outlook is not necessary.

Jim