I have a 97Access mdb that automatically sends out emails. A spreadsheet, which is the source file, is imported into the mdb, and each line is sent to a recipient indicated on a field from that line.
In more understandable terms, each line in the spreadsheet contains information for specific users. One of the fields in the line contains that person's name, which is identified in an Outlook Address book. So, the first cell in the line contains the name, and that cell is used by the access mdb to determine the recipient of said line.
This access mdb is deployed on a users machine who knows nothing about access, so I need it to be automated as much as possible. All of this happens with the click of a button on a form (import spreadsheet, build sendout table, email recipients line-by-line to recipient indicated in said line).
The problem I'm having is that sometimes one of the names on the spreadsheet is misspelled, causing Outlook to throw an error (Spreadsheet says 'Rob' when Outlook only knows 'Robert,' etc.). In my ideal fix, I'd like to throw some code into the module that will import his Outlook address book, then only attempt to send the mail if the recipient matches a legit recipient in his address book. If it doesn't match, I could throw the name into an array and after it's finished let him know who, if any, failed to get the mail.
I'd like this to happen automatically every time the mdb runs, because the possible recipients are constantly changing, because people are quitting and being fired and being hired and rehired on a weekly basis. So, every time he runs the process, a new sample of his outlook address book will need to be re-imported for comparison.
Thanks,
Chris.
In more understandable terms, each line in the spreadsheet contains information for specific users. One of the fields in the line contains that person's name, which is identified in an Outlook Address book. So, the first cell in the line contains the name, and that cell is used by the access mdb to determine the recipient of said line.
This access mdb is deployed on a users machine who knows nothing about access, so I need it to be automated as much as possible. All of this happens with the click of a button on a form (import spreadsheet, build sendout table, email recipients line-by-line to recipient indicated in said line).
The problem I'm having is that sometimes one of the names on the spreadsheet is misspelled, causing Outlook to throw an error (Spreadsheet says 'Rob' when Outlook only knows 'Robert,' etc.). In my ideal fix, I'd like to throw some code into the module that will import his Outlook address book, then only attempt to send the mail if the recipient matches a legit recipient in his address book. If it doesn't match, I could throw the name into an array and after it's finished let him know who, if any, failed to get the mail.
I'd like this to happen automatically every time the mdb runs, because the possible recipients are constantly changing, because people are quitting and being fired and being hired and rehired on a weekly basis. So, every time he runs the process, a new sample of his outlook address book will need to be re-imported for comparison.
Thanks,
Chris.