I have a routine to print envelopes from a database using Printer Object and I am trying to make it prompt between each envelope.
The code looks something similar to this:
Do Until rstRecSet.EOF
rsp = MsgBox("Insert envelope and click OK, vbOKOnly)
What I get is my Message Box prompt immediately x number of times in a row (however many addresses I have to print) before any printing even starts.
How can I code it to prompt me, print one and then prompt me for the next one (without having to do something like reselect the printer each time?)