See my examples that not need a reference because they use late binding
http://www.rondebruin.nl/sendmail.htm


"gab1972" wrote:

On Aug 3, 2:31 pm, ryguy7272
wrote:
If the code works fine one one machine and errors on another machine, it is
probably an issue with a reference. Check this out:http://www.cpearson..com/excel/References.htm

Alt + F11 Tools References Microsoft Object XX.X Object Library
for me, the XX.X = 10.0; yours may be different...depends which version of
Excel and Outlook you are on.

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''..

"gab1972" wrote:
I have a spreadsheet with a macro that takes some information and puts
it in an email. It works fine for me, but when I give the spreadsheet
to someone else and they click the macro button, an error occurs
letting the user know that permission to outlook is not permitted. Is
this an 'owner' issue? I went into File Properties and deleted
myself as the author. However, I do see that my name is still in as
the owner. If I am the owner and someone else uses the program and
tries to open email...does outlook automatically try to open the
'owners' outlook and that is why there is a permission error?

Any help would be appreciated.

Thanks for the fast reply Ryan. Everyone in my building has the same
version of Outlook. I had set the reference library already. Mine is
Microsoft Office 11.0 Object Library. We are using Office 2003. When
I passed on the spreadsheet to other users, I made them go in and
check to make sure they had the same library references as me. Still,
I get the permission error. That's why I was wondering if maybe
because the file properties have me listed as the owner if maybe
Outlook will only access email where I am logged in??? If this is the
case, can I VBA some coding to remove ownership? Or do all files have
to have an owner? Or can I VBA some code to assign an owner?