asked on

How can I enable the Send to Mail Recipient (as attachment) button in Excel 2003 -- it worked in E2002

I've added the Mail Recipient (as Attachment) button to my File Menu, but it is always disabled. The option is always enabled for me on another computer with Excel 2002. I use Mozilla Thunderbird as the default mail program on both computers.

Grizzly072000

View/Toolbars/Customize/File
Go down to the Send to item and drag it to some toolbar on top.

Grizzly072000

Oops: Not "Send To" but "Mail Recipient". Sorry...

pteranodon72

ASKER

I've put the button in place, but the problem is that it is not enabled (it's grayed out).

Grizzly072000

Did you select VBA when installing Excel?

pteranodon72

ASKER

I didn't do the Office installation (it's a work machine), but I have administrative rights.
I can use VBA in Modules and I've got Macro Security set to Low, if that's at all helpful.

SOLUTION

Grizzly072000

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Grizzly072000

Another way of disabling VBA can be found in: Some Excel features are unavailable if you disable Visual Basic for Applications and run Excel
http://support.microsoft.com/kb/282847/

pteranodon72

ASKER

I've added .Net Programmability Support as described above. VBA is definitely enabled -- I can record / write macros. I do have one Send To item enabled now -- Send for Review . . . , but that involves sharing the workbook, tracking changes, etc. I'm just looking to activate the

Mail Recipient (as Attachment)

command that I've added to the File menu (it's always gray) so that I can email the current document without having to close it in Excel and then browse to the $%^$%# path from Thunderbird.

Thanks for the attention.

ASKER CERTIFIED SOLUTION

pteranodon72

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial