helderw
11-15-2013, 05:00 AM
Hi everyone,
I need some help so solve this one. I have an excel file that is used by a lot of people in my company but some of us have Excel+Outlook 2013, others 2010 and some still with 2007.
The porpose of the excel file is to send an email to a list of contacts. After someone with a more recent version of the Office runs the macro, those who have an older version get an error message and shows up the debug window with the vba code.
The solution we have right now is to manually uncheck the current "Microsoft Outlook Object Library Reference" and check an older version "Microsoft Outlook Object Library Reference".
However I believe there is a way to go around this but I don't know how.
Thank you for your help.
I need some help so solve this one. I have an excel file that is used by a lot of people in my company but some of us have Excel+Outlook 2013, others 2010 and some still with 2007.
The porpose of the excel file is to send an email to a list of contacts. After someone with a more recent version of the Office runs the macro, those who have an older version get an error message and shows up the debug window with the vba code.
The solution we have right now is to manually uncheck the current "Microsoft Outlook Object Library Reference" and check an older version "Microsoft Outlook Object Library Reference".
However I believe there is a way to go around this but I don't know how.
Thank you for your help.