Click here to Skip to main content
15,896,727 members

VB.Net Sending an Email Using Outlook

thajudeen301190 asked:

Open original thread
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
Tags: Visual Basic, PowerShell, Outlook, Microsoft Access

Plain Text
ASM
ASP
ASP.NET
BASIC
BAT
C#
C++
COBOL
CoffeeScript
CSS
Dart
dbase
F#
FORTRAN
HTML
Java
Javascript
Kotlin
Lua
MIDL
MSIL
ObjectiveC
Pascal
PERL
PHP
PowerShell
Python
Razor
Ruby
Scala
Shell
SLN
SQL
Swift
T4
Terminal
TypeScript
VB
VBScript
XML
YAML

Preview



When answering a question please:
  1. Read the question carefully.
  2. Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
  3. 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.
  4. 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.
Please note that all posts will be submitted under the http://www.codeproject.com/info/cpol10.aspx.



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900