Unable to print multiple copies of a one page document

[Dominic]

I am using Word'07 and I am unable to print multiple copies of a one page
document in Word and Excel. I can print multiple pages via quickbooks but jut
not with Office. What do i need to do to correct this? I select "x" amount in
the print page after i select print. This time i selected 45 and hit print,
it only printed one.
please help

 

[Beth Melton]

I am using Word'07 and I am unable to print multiple copies of a one page
document in Word and Excel. I can print multiple pages via quickbooks but
jut
not with Office. What do i need to do to correct this? I select "x" amount
in
the print page after i select print. This time i selected 45 and hit
print,
it only printed one.
please help

What kind of printer do you have? HP printers are known to cause this issue.
Try updating the printer driver with one from the manufacturer's web site
and see if that resolves it.

Also, here's a KB article that should still be applicable to Word 2007:
http://support.microsoft.com/kb/290956

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx

 

[Dominic]

Thank you Beth. It in fact an HP laser printer.
so just update the drive via the hp site?

 

[Beth Melton]

That's definitely something to try. Did you look at the KB article I cited
to see if your model had a workaround in Word? Here's the link again:
http://support.microsoft.com/kb/290956

Thank you Beth. It in fact an HP laser printer.
so just update the drive via the hp site?

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx

 

[Dominic]

Beth!!!! I love you!!. so i read the workaround you posted and read what made
sense to me. i changed "print directly to printer" and bam it worked,..,,
thank you so much for you time and suggestion...

 

[Dominic]

hmm so any idea for excel? i figured this would take care of both,,

 

[Beth Melton]

I also think the same fix would correct Excel. I dug around a bit and found
a VBA (macro) solution in this KB:
http://support.microsoft.com/kb/112037

Even though it cited Excel 5 the macro is still applicable. You may want to
ask about this in one of the Excel newsgroups as well. But if you want to
use the macro method, follow these steps:

- If you don't see the Developer tab in the Ribbon, click the Office Button,
Click Excel Options, and in the Popular section select "Show Developer tab
in the Ribbon"

First you need to create a Personal Macro Workbook in order to macro your
print macro available to all workbooks:
- On the Developer tab, click "Record Macro".
- Type "SampleMacro" in the Macro Name text box
- From the "Store Macro in" drop down select "Personal Macro Workbook"
- Click OK
- Click "Stop Recording" on the Developer tab

Then:
- In the KB article, copy the Example macro
- In Excel, on the Developer tab, click Visual Basic
- On the left side of the Visual Basic Editor locate "Personal.xlsb" and
select it
- From the Insert menu, click Module
- Paste the copied macro from the KB article in the newly created module.
- Change the name from Example to "PrintMultipleCopies"

To use the macro you can add it to your Quick Access Toolbar (QAT):
- Right-click the QAT
- Click "Customize Quick Access Toolbar"
- From the "Choose Commands From" drop down, select "Macros"
- Locate your PrintMulitpleCopies macro, select it and then click Add

You can customize the icon using the "Modify" button below the list of
commands on your QAT.

Also note when you exit Excel you should be prompted to save changes to your
Personal Macro Workbook (Personal.xlsb). Make sure you confirm the save or
your changes will be lost.

hmm so any idea for excel? i figured this would take care of both,,

--
~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton
What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

Guides for the Office 2007 Interface:
http://office.microsoft.com/en-us/training/HA102295841033.aspx