How do I send email messages via Access using addresses from a table? The message will be different for each receiver.
Posted on 2005-04-20
We need to send email messages to about four hundred persons. The email letter being sent to each of them will indicate that they have been accepted into a special program (the email will tell them which program); they have been awarded a certain amount of money to work with (the email will tell them how much); and they will be given a contact person, number and address to call (the email will given them that information also). The table has all of the information they need and a filter will separate the selected person from the those not selected. We use Outlook and would like for this to be close to automatic where we do not have to create separate letters and cut-n-paste into email messages. The subject line will be the same for all messages. The return will be from the user who is signed onto the system.
We have MS Word and can use it in conjunction with Access, if necessary.
Any ideas? A simple solution, if possible, will be appreciated since we don't know a lot about the technical end of Access.