Activating the Send As Attachment option

[Becky]

My "send as attachment" option is disabled. How do I activate it? (In simple
terms, please)

 

[Ron de Bruin]

Hi Becky

Try the things on this page
http://www.rondebruin.nl/mail/problems.htm

 

[Don Guillett]

If not already on your toolbar then
right click toolbar>customize>commands>file>look for it and drag to toolbar

 

[Becky]

Thanks, Ron, but the "send as attachment" is the only function that doesn't
work. I can send for review and I can send an individual page in an email.
I've added the send as attachment icon in my toolbars at the top, and it used
to work. All of a sudden it is grayed out and I can't use it. Is there a
setting I'm not seeing?

 

[Becky]

I have done this, and it has worked for me in the past. However, the icon
has been grayed out the past two days and I'm not sure what has changed. Is
there a setting?

 

[Ron de Bruin]

Check out number 2 on my page

 

[Becky]

The "MAPIX=1" that #2 suggests is already there. Any other ideas?

 

[Ron de Bruin]

Hi Becky

Try to rename your .xlb file

maybe you have a corrupt or bloated xlb file
*normal* size is < 30 kb.
The .xlb file has all Toolbar customization in it.

Close Excel
Do a search for .xlb in windows
Rename the file you find (mine is named Excel10.xlb in 2002)
Start Excel

Deleting the file or renaming will do no harm on your system
Excel will create a new one for you.
(You lost your customization remember that)

If you make your own toolbars or add buttons to the others
This file is important (backup it so you can restore it)

 

[Don Guillett]

try
Application.CommandBars.FindControl(ID:=30095).Controls(1).Execute