PDA

View Full Version : Solved: Check Outlook version



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

Bob Phillips
08-31-2007, 03:38 AM
Why bother, develop in 2003 and it should work okay in 2007.



Set OL = CreateObject("Outlook.Application")