Click here to Skip to main content
Sign Up to vote bad
good
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:49
Edited 14 Feb '13 - 18:23

Comments
aspnet_regiis -i - 14 Feb '13 - 2:28
So what's the problem with this? What exact help do you need?
thajudeen301190 - 14 Feb '13 - 2:37
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.
aspnet_regiis -i - 14 Feb '13 - 2:29
And I guess you missed to post your twitter id .. :laugh:
thajudeen301190 - 14 Feb '13 - 2:37
:p...I dont have twitter boss.
aspnet_regiis -i - 14 Feb '13 - 10:08
So .. Whats up.. How was the day today.. Any progress in this task ?

1 solution

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
  Permalink  

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

  Print Answers RSS
Your Filters
Interested
Ignored
     
0 Sergey Alexandrovich Kryukov 278
1 Mohammed Hameed 268
2 OriginalGriff 236
3 Mayur_Panchal 153
4 Dave Kreskowiak 125
0 Sergey Alexandrovich Kryukov 8,171
1 OriginalGriff 6,236
2 CPallini 3,482
3 Rohan Leuva 2,703
4 Maciej Los 2,234


Advertise | Privacy | Mobile
Web04 | 2.6.130516.1 | Last Updated 15 Feb 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid