Print on both sides and flip short edge

[Wardylewis]

Good Afternoon,

I have developed a form in Excel and Word have managed to create a User form for the user to select which printer they want the forms sending to.

I have however now become stuck with getting it to do duplex printing.

I am trying to find but am struggling how you tell both Excel and Word to print on both sides and flip short edge.

Can anybody assist?