I think in this case you are stuck with using late binding.
Change all your Outlook type variables to simple Objects, e.g.,
change
Dim AddrEntry As Outlook.AddressEntry
to
Dim AddrEntry As Object

and create the Outlook Application using CreateObject or
GetObject.

Dim OL As Object
On Error Resume Next
Set OL = GetObject(, "Outlook.Application")
If OL Is Nothing Then
Set OL = CreateObject("Outlook.Application")
End If


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Bret" wrote in message
...
I have an Excel VBA program that is distributed throughout our
company
nationally (1000 users). One of the features is ability for
user to click a
button and it opens up Outlook with Send to, Subject and a
message all filled
in and user can of course just click the SEND button.
It works for majority of users who have Outlook 2003 however a
large portion
of users have older Outlook versions that creates a compile
error or missing
Reference errors, again program uses Outlook 11.0 library.
What can be done in code or with references so this feature
works with all
users who either have Outlook 2003 or the version before this?

thanks