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?