MS Access & Lotus Notes

[Coll]

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

[Tom van Stiphout]

On Sat, 19 Apr 2008 17:58:19 -0700 (PDT), Coll
<co*********@hotmail.comwrote:

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