MS Access & Lotus Notes

I manage a few databases that have macros that generate email
reminders to groups of individuals. These macros work correctly on my
computers as well as one of my coworkers. However, the people who are
actually supposed to send these reminders are having problems. When
they run the macro, a new Notes message pops up with all the
appropriate data (the email messages pull data from fields in Access),
however, the message is only addressed to one recipient (the first one
listed in the database for that group). Any ideas? I think we are all
using the same versions of Access & Notes (Access 2000; Notes Release
6.5.4). Our IT department has not been able to help (they "don't
support Access"). I'm not sure if it's an Access issue or a Notes
issue. Any ideas would greatly be appreciated. Thanks.

Colleen

Re: MS Access & Lotus Notes

On Sat, 19 Apr 2008 17:58:19 -0700 (PDT), Coll
wrote:

Could you use one of their computers for a day to debug this further?
Can you break down the code to its essence and post it here?
Are you using proper error handling?
You *think* everyone is on the same version? How about making sure?
Sometimes the object model has a toplevel object with a Version
property. In lieu of that, use the About box or the Version
information of the main EXE file. This goes for Notes as well as
Access.
Everyone is running Windows Update, right? (when they say Yes, you may
want to double-check anyway)

-Tom.


>I manage a few databases that have macros that generate email
>reminders to groups of individuals. These macros work correctly on my
>computers as well as one of my coworkers. However, the people who are
>actually supposed to send these reminders are having problems. When
>they run the macro, a new Notes message pops up with all the
>appropriate data (the email messages pull data from fields in Access),
>however, the message is only addressed to one recipient (the first one
>listed in the database for that group). Any ideas? I think we are all
>using the same versions of Access & Notes (Access 2000; Notes Release
>6.5.4). Our IT department has not been able to help (they "don't
>support Access"). I'm not sure if it's an Access issue or a Notes
>issue. Any ideas would greatly be appreciated. Thanks.
>
>Colleen