VB.Net Sending an Email Using Outlook

Question

0.00/5 (No votes)

See more:

Back End : Ms Access
Front End : Vb.Net or Asp.Net or Powershell
Mailing : Outlook or server side(gmail or yahoo)

I need to retrieve the data from database and send an email to the user.

Scenario for Example:

Database looks like below,

Product_ID Product_Name Date_Of_Purchase Email_ID
p00001 Mouse 02/14/2013 thajuthemoon@gmail.com
p00002 KeyBoard 01/11/2013 thajudeentaj@gmail.com
p00003 Cleaner 01/29/2013 thajuthemoon@gmail.com
p00004 Monitor 10/10/2012 thajudeen301190@gmail.com

Output:
--------
I need like below,
View in Outlook.
Example 1:
From : thajuthemoon@gmail.com
To : thajuthemoon@gmail.com

Product ID Product Name Date of Purchase
p00001 Mouse 02/14/2013
p00003 Cleaner 01/29/2013

Example 2:

From : thajuthemoon@gmail.com
To : thajudeentaj@gmail.com

Product ID Product Name Date of Purchase
p00002 KeyBoard 01/11/2013

In one mail what are all the items the particular user purchased, it should go like above.
It should be in loop, next mail should go to the next user, next user next user.

Can anyone help me in this issue.
I am able to retrieve and send the mail by giving input.
I need it, without giving in input, it should be automated.

Please let me know if anyone know this program how to do, or any can suggest me how to do.
You can reach me @
[Email Deleted]

Regards,
Thajudeen

Posted 13-Feb-13 18:49pm

thajudeen301190

Updated 14-Feb-13 18:23pm

Abhishek Pant

v2

Add a Solution

Comments

bbirajdar 14-Feb-13 2:28am

So what's the problem with this? What exact help do you need?

thajudeen301190 14-Feb-13 2:37am

I need a code, how it works.
How to send an email in loop by retrieving the data according to the email.
It should be in automated. No Manual Work.

bbirajdar 14-Feb-13 2:29am

And I guess you missed to post your twitter id .. :laugh:

thajudeen301190 14-Feb-13 2:37am

:p...I dont have twitter boss.

bbirajdar 14-Feb-13 10:08am

So .. Whats up.. How was the day today.. Any progress in this task ?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jameel VM · Answer 1 · 2013-02-14T18:16:00

Solution 1

You can send mail from Outlook by using Exchange web Services. The below link will help you.
http://code.msdn.microsoft.com/Send-Email-with-Exchange-50189e57[^]

Examples on MSDN
http://msdn.microsoft.com/en-us/library/ms878112[^]
Hope this helps

Posted 14-Feb-13 18:16pm

Jameel VM

Updated 14-Feb-13 18:18pm

v2