• Printing All Excel Attachments

    Author
    Topic
    #458534

    Our office check request form was created in Excel, and I’ve finally trained everyone to email me their check requests, with the completed form attached. My problem is that although I’ve convinced Outlook to open the files without squawking (.xls format, since not everyone in firm uses Office 2007 yet), Outlook refuses to print all the attachments if there are more than one attached. Sometimes it stops after printing the first attachment, and other times I get most of them, but not all, necessitating me to open each attacment and check which ones printed and which didn’t.

    I don’t have this probelm with other attachments, such as Word docs (both .doc & .docx formats) or Adobe .pdf files. After having missed issuing checks several times, I now right-click on each attachment and print them all indvidually, but I’d love to be able to save those extra steps and have all attachments print reliably when I print the email message.

    Any suggestions?

    Viewing 1 reply thread
    Author
    Replies
    • #1153373

      I now right-click on each attachment and print them all indvidually, but I’d love to be able to save those extra steps and have all attachments print reliably when I print the email message.

      I don’t know why this feature is flaky for you. (I actually do not print attachments with my messages, ever.)

      Did this problem just start with Outlook 2007? Does it matter whether the email is in plain text or HTML format?

      • #1153491

        I don’t know why this feature is flaky for you. (I actually do not print attachments with my messages, ever.)

        Did this problem just start with Outlook 2007? Does it matter whether the email is in plain text or HTML format?

        I’m pretty selective about what attachments I’ll print with my messages, but since I created this attachment and it’s only used in-house, I do print the check requests without running them through the virus checker.

        The problem didn’t exactly start with Outlook 2007, but that’s the only version I’ve used since insituting the policy of emailng check requests, so I can’t speak to how things would have worked under Outlook 2003.

        I just tested the difference between plain text and rich text format (yesterday’s message that prompted my plea for help). Both email formats printed all 8 attachments. My only theory now is that calling for help from the Lounge caused Outlook to decide to quit tormenting me — at least while someone else is looking. I’ll let you know if it reverts to it’s old tricks.

    • #1153717

      Ah-ha! I think I’ve found the culprit. If Excel is already opened, all the attached forms print. If Excel is not open when I try to print the email message, Excel loads, prints the first attachment, closes and then forgets to re-open to print the remaining attachments.

      Of course this doesn’t explain why sometimes Excel would re-load to print some of the attachments if there are more than one, but never all of them. No matter, now that I know how to control the results, I’ll make sure I have Excel open before printing email messages with spreadsheets attached.

    Viewing 1 reply thread
    Reply To: Printing All Excel Attachments

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: