Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Send File as Attachment (EXCEL XP)

    Using EXCEL XP and XP Pro SP1...have just noticed that the "Send File as Attachment" under the Send to on the File drop down box is gone (i.e. not greyed out, but gone). While I was typing this message, I decided to go check MS Word (XP version) and its gone from the Send to menu in that application. I have not added any EXCEL add-ins recently and the IT department states nothing has been updated in the last two weeks. Ran a virus scan and the machine is clean. The PC also appears void of adware at least according to adware and spybot using their respective current definitions. Does anyone know how the "Send File as Attachment" disappeared and more importantly how do I get it back? I haven't found anything in Google groups or with MS knowledge base....Pls help! THANKS.

  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    In xl try

    Tools|Customize|Commands Tab. Click on Mail Recipient and drag up and drop it on Send To under File

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    I did this for both EXCEL and MS WORD XP and it returns the Mail Receiptant as Attachment to the Send to options on the file menu; however, now its greyed out under both applications. Whether I take an existing EXCEL file created previously or create a new worksheet from scratch, the send to Mail Receipant as Attachment stays greyed out. Same for MS Word. Assuming the IT group didn't change anything or apply any patches, I am at a loss as to how it disappeared to begin with and now that its been restored why its greyed out. The only way I can add an EXCEL or Word attachment is to use Outlook XP and attach the file via the menu or paper clip icon. Any additional guideance is appreciated. If it helps, I am using EXCEL XP SP3, Build 10.6501.6626

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send File as Attachment (EXCEL XP)

    You might try a repair installation of your default mail program (Outlook?).

  5. #5
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    Hans,
    No change after the re-install of Outlook XP...both EXCEL and MS Word have the send to file attachment selection--but it stays greyed out. Any other ideas? THANKS

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Send File as Attachment (EXCEL XP)

    I once had this problem in Office 97. In the end, a clean install of the entire PC was the only thing that solved it completely, but that is a rather drastic step. You may want to live with the current situation.

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Send File as Attachment (EXCEL XP)

    Hi,
    If you open Internet Explorer, select Tools-Internet Options and then select the Programs tab, is Outlook listed as the default email program?
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    Yes, Outlook is listed as the default e-mail program. I wish I knew how this happened....Hans is probably correct in that the only way to fix it is to re-install Office....but, while I am not happy about it, I can still go to Outlook and attach the file versus having this luxory of a one-step process from EXCEL. I have no VB macros running or add-ins...this is a vanilla install of EXCEL every time it opens.....I still wonder if its a hot patch or something that the IT dept. did.
    THANKS.

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Send File as Attachment (EXCEL XP)

    If you open win.ini (Start-Run then type win.ini will usually start it, otherwise you can locate it in your windows directory and open it in Notepad), there should be a section headed [Mail]. It should look like this:
    <pre>[Mail]
    MAPI=1
    CMC=1
    CMCDLLNAME=mapi.dll
    CMCDLLNAME32=mapi32.dll
    MAPIX=1
    MAPIXVER=1.0.0.1
    OLEMessaging=1
    </pre>

    Does yours contain all those entries?
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Send File as Attachment (EXCEL XP)

    You may also want to try this:
    Start-Run, then type 'regsvr32 sendmail' without the quotes.
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  11. #11
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    Rory,
    This is all I have in the win.ini file (i.e., using the start-run):

    [WinFax]
    ExePath=C:PROGRA~1WinFax
    Fax Path=C:PROGRA~1WinFaxData
    Cover Path=C:PROGRA~1WinFaxCover

    Should I cover your lines into this file? THANKS

  12. #12
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    Rory,
    When I do what you requested with the (regsvr32 sendmail) I get this message box:

    DllRegisterServer in sendmail succeeded...then I click ok. Not sure if this is good or bad. OK?

  13. #13
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Send File as Attachment (EXCEL XP)

    Jim,
    If the registration succeeded, try restarting your PC and see if it helped. If not, then copy the additional data into win.ini, save and restart again. Note: the win.ini in theory applies to Outlook Express rather than Outlook but I figure it's worth covering all bases at this point! If neither of those do the trick, try changing your default email program to Outlook Express, see if that works, then change it back to Outlook and see if that helps. If none of that works, I'd like to double-check a couple of registry entries if you are willing.
    Regards,
    Rory

    Microsoft MVP - Excel

  14. #14
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Canton, Ohio, USA
    Posts
    270
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Send File as Attachment (EXCEL XP)

    Rory,
    YOU ARE THE GREATEST. When I re-started after the registration succeed, nothing changed. So I tried your next suggestion and copied your Mail statements to the win.ini file and re-booted....AND the send with attachment is no longer greyed out in either EXCEL or MS Word (i.e., and I have actually attached files and e-mailed).....this is GREAT! Many thanks. Somehow the win.ini does impact Outlook too...at least on my XP Pro PC. Again, thanks for working this through with me!!!

  15. #15
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Send File as Attachment (EXCEL XP)

    Jim,
    Glad it worked, but I'm not the greatest. Just The King! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •