M
Mike_Walrus
Hello
I have an excel spreadsheet that is shared on the network, and different
users have different versions of MS Outlook, some have outlook 98 and others
have 2003. Part of the spreadsheet has some automation that sends an email
out. When the spreadsheet is used by an outlook 2003 user the email is sent
out correctly. however after the outlook 2003 user if an outlook 98 user
attempts to send out an email there is an error message, and the user then
has to go into the VBA code and change the library reference from Outlook 11
to outlook 8. There doesn't seem to be a problem when the outlook 2003 (11)
user trys to send out an email after the Outlook 98 user. How can i get it
so the spreadsheet just automatically finds the right library file to use
regardless of the version of Outlook the user is running?
I have an excel spreadsheet that is shared on the network, and different
users have different versions of MS Outlook, some have outlook 98 and others
have 2003. Part of the spreadsheet has some automation that sends an email
out. When the spreadsheet is used by an outlook 2003 user the email is sent
out correctly. however after the outlook 2003 user if an outlook 98 user
attempts to send out an email there is an error message, and the user then
has to go into the VBA code and change the library reference from Outlook 11
to outlook 8. There doesn't seem to be a problem when the outlook 2003 (11)
user trys to send out an email after the Outlook 98 user. How can i get it
so the spreadsheet just automatically finds the right library file to use
regardless of the version of Outlook the user is running?