How to send email alerts through database?

Question

Hi ,
Good morning.
This is Prabhakar Reddy, i have a requirement, i,e
I need to send email alerts to there emails  to the visitors dynamically, through access database.
how to send that emails,please tells me steps to achieve this requirement.  because am new to this concept.
Thank you in advance

Prabhakar Reddy · Answer

Thank you mukesh..

Mukesh Km · Answer

Hi Prabhakar Reddy,
Please find the attachment.
I explained in detail.

Jignesh Trivedi · Answer

hi

please refer following link it might help you.

http://msdn.microsoft.com/en-us/library/office/aa167323%28v=office.11%29.aspx

i think for this you may use micro or VBA function

http://stackoverflow.com/questions/6736309/email-an-access-2007-report-automatically-every-night-with-no-user-action

Prabhakar Reddy · Answer

k k, but not a problem, a can change my db with access ato sql server, please share your code
thank you

Mukesh Km · Answer

I used to email in sql server using msdb.dbo.sp_send_dbmail .
I am sorry to say that I am not favour with Ms Access Database.
But,If you want, I am ready to share the logic to send mail using MSSQL.

Prabhakar Reddy · Answer

Am using Access Database and dotnet 3.5 version
and
visual studio 2008

Mukesh Km · Answer

Hi Prabhar Reddy,
Do you use sql server or MS Access ?
What is the version?