Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB NET
I will try to explain what I am trying to do to see if it's possible.
 
I have to send email reminders to clients. I can now just send bulk emails to all clients but
can't figure out how to tell each separate client about their own appointment time and date.
 
Right now I have a form and can query all upcomming appointments by date ranges.
The form has a datagridview and textboxes on it. It's all bound to a dataset.
I am able to fill a multiline texbox with the email and another textbox with the name of the client and the appointment date.
 
I understand if I send bulk emails as BCC's that the other clients will not see all of the email addresses, just their own.
 
However; since it's an appointment reminder I want to put the clients name and date of their appointment into the body of the email. The subject can be the same for all clients and would be something like "Just A Friendly Reminder".
 
Is there a way to do this and would anyone have examples that they can point me to. Doesn't have to be code, just some idea's where it's been done so I know it can be done. I don't want to send say 20 or 50 emails to separate clients, but if that's how it has to be done I would like to know the easiest automated way to do it.
 
I found a program that does this...how are they doing this through the software?
http://www.eveterinarysoftware.com/index.php/features/reminders/#!prettyPhoto[pg_1]/1/[^]
Posted 11-Mar-13 3:22am
Edited 12-Mar-13 2:33am
v3
Comments
Prasad Khandekar at 11-Mar-13 11:03am
   
Hello,
BCC (Blind carbon copy) is meant to send a single email to multipel recipients whithout them knowing that is also send to other people. In your case I am afraid you will have to send individual e-mails if mail has to contains recipient specific information.
 
Regards,
ryanb31 at 11-Mar-13 14:56pm
   
You have to create a loop and send one email at a time because your appointment details are unique. You have to check with your ISP because if you send too many emails over a given time frame they may blacklist you from sending emails.

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Something like this is called a mailmerge. Search it on google to find some good results on howto perform such operation.
 
For examle (a post on the bottom of the page has links to some examples):
http://social.msdn.microsoft.com/forums/en-US/vbide/thread/da93c076-34c2-4d3b-a026-835b4c0ba51d/[^]
 
Good luck!
  Permalink  

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



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 12 Mar 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100