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