How to send email alerts through database?

Question

Hi  Good morning. This is Prabhakar Reddy i have a requirement ie I need to send email alerts to there emails to the visitors dynamically through access database. how to send that emailsplease 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. ButIf 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?