MS Access - Auto Email alert

[edmundoab]

Hi Guys,

Just want to know the capabilities of MS access whether using VB programming or SQL
is it able to handle a request to send an auto email alert on certain conditions?

I am planning to have a vendor design a function in MS access where it can notify say a pending call ticket that exceeds 20 days. and the system will compare the current date with the ticket open date and send an email to the user's email (well basically the person who opened the ticket)

or is such function just totally out of bounds for MS access?
that I will need full SQL or something?

any opinions welcomed

 

[WannaFly]

I have not used access in many years, but am pretty sure this is outside the scope of what access can do. It is not a server based product and has no processes that always run, so it can't be done WITHIN access.

BUT - you can:
A) create an external program that queries the database and sends the email; schedule it via task scheduler or always leave it running
B) maybe automate access via command line to generate a report and email it. Schedule via task scheduler.

This would be a task for SSIS or a simple stored procedure in "full" sql - that can be scheduled to run via sql server agent (MSSQL)

 

[Crusty]

You can use the Outlook Object Library controls accessed through COM using VBA to send e-mails using Outlook from a PC running Access.

 

[edmundoab]

Thanks guys,
so that means there is a function within access that can somewhat link to our MS Outlook, in this case it should be sufficient as we are all using outlook for business emails