Making Word Macro Pause

Topic

New Reply

I have a Word macro that does a mail merge, sends it to the printer, renames the data source file and quits. But I need it to stop after the merge so that I can look at the file and tell if everything is correct. If it is then it can carry on, but if there are problems I have to edit that file and then carry on or abandon it and create a new data source file. I can’t for the life of me get anything to pause the thing and still allow me to work with the file. Help!?

Reply | Quote

Replies

Hi Gordon,

If you’re using Word 2000, create a modeless form. If you’re using Word 97, I don’t have a solution off-hand.

HTH,

Chris

Reply | Quote

I suggest you take a dual function approach. Run your merge with macro1. Let it stop (not pause) then examine for correctness. If all is ok, run macro2. By invoking the macros via a tool bar, you make the process very easy for the user. Button1: Start Merge, Button2: Continue Merge.

Would that approach work?

Reply | Quote

Thanks Chris for the modeless form idea. I’ll look into that one, but for right now I’m going to go with Kevin’s much less mentally taxing suggestion of breaking the action into two seperate macros. Thanks a lot.

Reply | Quote

Happy to be of service, especially at the expense of so little brain drain….

Reply | Quote

I think Kevin’s two macro notion probably would give users more of a sense of control (“Either I like the merge or I don’t”).

But, if you want to try the modeless form, set the ShowModal property of a form to false. Then, when you show the form, the user can activate the Word instance and check it out. Of course, the form will still be visible so you don’t want it to be *too* big.

Reply | Quote