I would first like to advise that my organization has 3 different versions of Office in play at the moment. All of our users run Access 2003 but the rest of the Office suite are 2007 (i.e. Outlook). To further confuse things, a handful of folks are testing Office 2010 at this point but they remain using Access 2003 as our BI does not support 2007 or 2010. That said, I have been searching all over and reviewing articles about the use of VBA to send an Outlook message from Access. It appears that everything was good until Office 2007 came along and things really started to get hosed up.
I am hoping that someone is currently using VBA in a mixed environment today and can lend a hand or finger in the right direction. I have a form that currently evaluates user names and fires a message based upon the name and specified event. I would like to add one more piece to that by firing off an e-mail to the supervisor of that associate when this event happens.
Anyone able to help me out here by chance?