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.