<div>
You can use sp_send_dbmail to send emails.<br />
<br />
For more details please refer - <a href="https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql" rel="ugc">https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql</a>
</div>


You can use sp_send_dbmail to send emails.

For more details please refer - https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql [https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql]

<div>
Thanks Pawan Kumar<br />
<br />
By the procedure, i can send a single file to multiple email ids but i want some solution to generate multiple files and send to their respective head of the departments.
</div>


Thanks Pawan Kumar

By the procedure, i can send a single file to multiple email ids but i want some solution to generate multiple files and send to their respective head of the departments.

<div>
create separate table with recipient, massage body, is sent, etc. and insert attendance data to that table, and create sp to send mail from your table. and then schedule your own SendDbMail sp as you need.
</div>


create separate table with recipient, massage body, is sent, etc. and insert attendance data to that table, and create sp to send mail from your table. and then schedule your own SendDbMail sp as you need.

<div>
&gt;&gt;but i want some solution to generate multiple files <br />
<br />
Multiple files means? Do you want to send multiple files as attachment ?
</div>


>>but i want some solution to generate multiple files

Multiple files means? Do you want to send multiple files as attachment ?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I want to send email groupwise. For example, i want to send emails to department heads for the people working in their departments. I have 10 departments so need to send 10 emails to their heads regarding the attendance of their respective department staff. <br />
<br />
Any solution, plz advice
</div>
</div>


Hi

I want to send email groupwise. For example, i want to send emails to department heads for the people working in their departments. I have 10 departments so need to send 10 emails to their heads regarding the attendance of their respective department staff. 

Any solution, plz advice

Group Emailing from SQL SERVER

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

An email client, email reader or more formally mail user agent (MUA) is a computer program in the category of groupware environments used to access and manage a user's email. A web application that provides message management, composition, and reception functions may internally act as an email client; as a whole, it is commonly referred to as webmail. Likewise, email client may be referred to a piece of computer hardware or software whose primary or most visible role is to work as an email client. Email clients can also have other systems, like calendars, notes and contact managers.

Email Clients

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.