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.

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.

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?

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?

Follow Ron's advice; use late binding.

Good luck,
Ryan---

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


"Ron de Bruin" wrote:

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?

On Aug 3, 3:36*pm, ryguy7272
wrote:
Follow Ron's advice; use late binding.

Good luck,
Ryan---

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

"Ron de Bruin" wrote:
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?

I will be trying this. I changed my coding around like Ron
suggested. I'll let you know if this method worked better for my
users.

Thanks in advance

Okay, so I followed Ron's advice and used his coding. However, I'm
still getting a permission error when someone else uses the
spreadsheet. I have a macro assigned to a button. It opens an email,
fills in the subject and body, adds some attachments, and then waits
for the user to input an email address. It works fine for me. I
created the spreadsheet and it is stored on a shared drive. However,
when another user logs into their computer and tries to use it, it
says that they do not have permission.

gab1972 wrote:
On Aug 3, 3:36*pm, ryguy7272
wrote:
Follow Ron's advice; use late binding.

Good luck,
Ryan---

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

"Ron de Bruin" wrote:
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?

I will be trying this. I changed my coding around like Ron
suggested. I'll let you know if this method worked better for my
users.

Thanks in advance