PDA

View Full Version : Word office Mailings (VBA) - automatic printing with stapling



MinEdi
09-20-2021, 04:26 AM
Hello!
I'm looking for solutions to my problems...
Topic: Microsoft office 2016, Word - Mailings Tab/VBA/Print
The document is multi-page and I print the records one by one, because the printer is stapling the pages (max. Record currently: 20 pcs.). I want this process to work automatically, so I can save time without error.
I encountered two obstacles here.
1. I have the first record, next record (variable It’s how many records I have). I don't know what it looks like in VBA. Only scan records and send them for printing as long as there is a record.
2. Print with the top left staple.
Thanks!

Chas Kenyon
09-20-2021, 12:00 PM
Stapling is not something in vba. It is in your printer driver. You could create separate documents in your merge and then print them.
Individual merge letters by Graham Mayor, MVP (http://www.gmayor.com/individual_merge_letters.htm)

MinEdi
10-04-2021, 02:03 AM
Thank you for your reply!

Chas Kenyon
10-04-2021, 12:32 PM
You are welcome.