Sherman6789
Programmer
Hello,
We need to send email messages to several dozen persons. Each will get a separate (different) message. 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. Each message can have up to three (3) cc:. The return will be from the user who is signed onto the system. I'm guessing that I need to add three fields: "cc1", "cc2" and "cc3". These will hold the cc: addresses. The "emailaddress" field will hold the address of the person receiving the mail. 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.
Thanks!
We need to send email messages to several dozen persons. Each will get a separate (different) message. 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. Each message can have up to three (3) cc:. The return will be from the user who is signed onto the system. I'm guessing that I need to add three fields: "cc1", "cc2" and "cc3". These will hold the cc: addresses. The "emailaddress" field will hold the address of the person receiving the mail. 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.
Thanks!