Create Excel File On The Fly And Send As An Email Attachment In Console Application

We are going to write this Excel file with name “DataFile.xlsx”.

GetExcel class code Snippet

Now we need to call ExportDataSetToExcel() Method in getData() Method.
After calling this method we have completed with creating Excel file on fly now we are going send this file with Mail as attachment.

Adding New Class and Method to SendMail

For adding class just right click on project then select add inside that select New item and from template select class and then name class as “SendMail.cs”,



Inside that Class we are going to add Method with name SendMail.

Below is code Snippet of SendMail Class.
Let’s understand code snippet of SendMail

Part 1

In this code snippet we are getting Excel file path and then attach this file to Mail.
Part 2

In this code snippet we are sending Mail.

For sending mail we require Host name.
Part 3

For setting mail from and Mail to,
Part 4

For setting CC and BCC (required mail in comma separated format),
Part 5

For setting Mail Subject and Mail Body,
Part 6,

For setting Attachment.
Part 7

For setting port number and Gmail ID Credentials for sending mail.
After completing send mail now let’s call this method in main.

Main method Code snippet

Here we have called both class methods.
Now we have completed code part let’s checking this method in debug view.

Debug View

Below snapshot of Dataset while getting data,



Below snapshot of Creating Excel file in specific folder on fly,



Below snapshot of Main Method while debugging,



Below snapshot of Sending Mail Method

I have pinned some variable while debugging to showing real time values.



Mail received to my Gmail.







Now we have Sent Mail now let’s schedule this to Task Scheduler to send this to client in every 2 hour.

Scheduling Task

Just in windows Run type task then select Task Scheduler.



After selecting Task Scheduler a new dialog will pop up with name Task Scheduler.

Task Scheduler view


From Task Scheduler dialog there is Actions panel inside that select Create Task.

After selecting it will open new dialog inside that it will ask for task Name I have named as “MailTask” then need to enter Description “Mail Scheduler for Every 2 hours” this will help you to remember for what purpose you have create this Scheduler.

Then in Security option we are going to choose “Run whether user is logged on or not” below we are also going to check checkbox.

Finally we want this scheduler to run on high privileges for that we are going to check checkbox.

After doing all setting click on OK button.

You setting you can see below snapshot.

Create Task view


After clicking on OK button it will show a message to add a Task click on Ok button.



Create Action view Now after clicking it will take you to Action tab.



In New action tab just select new button [New] a new dialog will pop up as shown in below snapshot.



After in Action we are going to select “Start a Program”.

Then click on browse option for selecting program which should run on scheduling we are going to select .exe of our project which should run after every hour.

The .exe [MailScheduler.exe] is located in your bin folder of project and its name is same name as project name. In below snapshot I am displaying how to select .exe [MailScheduler.exe] file.

Selecting program view (selecting MailScheduler.exe),





After selecting program just click on ok button a similar dialog must appear.

View after (selecting MailScheduler.exe)



If you want to edit or delete this action you can select button below,

Let’s now we are moving forward to set trigger.

Setting Trigger

For that select Trigger tab as shown below.



In New Trigger tab just select new button [New] a new dialog will pop up as shown in below snapshot.



Settings

Inside setting we are going to select Daily option then it will be a Recur every 1 days.

Advanced settings

Select checkbox “Repeat task every” from dropdown select 2 hours if it is not there then you can enter it.

Then to set “for a duration of “from dropdown select 1 day.

Finally click on ok button you have successfully configured scheduler.

After scheduling it should display in Active Task Panel.



Final mail after scheduling.

Finally we have mate Client Requirement.