zennon
08-31-2007, 03:35 AM
Hi,
I have create a worksheet that emails out various sheets to various people. We were using OL 2003 but some people have upgraded to OL2007. Instead of me creating 2 versions on the workbook is there a way that I can get VB/Excel to check the verison they are using.
I'm using this line: Set OL = CreateObject("Outlook.Application.12") where 12=2007 or 11=2003 when sending the email message.
Can this be done?:dunno
I have create a worksheet that emails out various sheets to various people. We were using OL 2003 but some people have upgraded to OL2007. Instead of me creating 2 versions on the workbook is there a way that I can get VB/Excel to check the verison they are using.
I'm using this line: Set OL = CreateObject("Outlook.Application.12") where 12=2007 or 11=2003 when sending the email message.
Can this be done?:dunno