puase needed for SendKeys action

[Phil M]

I am using the SendKeys action to callup MSword MailMerge
in order to print a record. Unfortunately the delay
while MSWord is opening causes the ^p (ie, the "print"
command) keystroke to arrive too early. Nothing happens.

I've tried breaking up the SendKeys action into various
length segments and seting the 'Wait" argument to "yes"
for the relevant segments, but this strategy has failed
completely. The macro just stalls after the "Wait: Yes"
segment.

I need some way for the macro to pause for three seconds
while it is running. Any suggestions?

Yes, I know that I can break the macro into separate
macros and use the timer on a form. Is there any other way
to handle this problem?

(I am using MSWord MailMerge because Access Reports can't
handle the complicated formatting that I require.)

 

[Steve Schapel]

Phil,

Yes, I know that I can break the macro into separate
macros and use the timer on a form. Is there any other way
to handle this problem?

No.

- Steve Schapel, Microsoft Access MVP