Consulting

Results 1 to 4 of 4

Thread: Word office Mailings (VBA) - automatic printing with stapling

  1. #1
    VBAX Newbie
    Joined
    Sep 2021
    Posts
    2
    Location

    Post Word office Mailings (VBA) - automatic printing with stapling

    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!

  2. #2
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    119
    Location
    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

  3. #3
    VBAX Newbie
    Joined
    Sep 2021
    Posts
    2
    Location
    Thank you for your reply!

  4. #4
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    119
    Location
    You are welcome.

Tags for this Thread

Posting Permissions

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