Results 1 to 6 of 6
  1. #1
    GordonWH
    Guest

    Making Word Macro Pause

    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!?

  2. #2
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Oregon, USA
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making Word Macro Pause

    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

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making Word Macro Pause

    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?
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  4. #4
    GordonWH
    Guest

    Re: Making Word Macro Pause

    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.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    Hollywood (sorta), California, USA
    Posts
    2,759
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making Word Macro Pause

    Happy to be of service, especially at the expense of so little brain drain....
    <img src=/S/smash.gif border=0 alt=smash width=30 height=26>
    <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Kevin <IMG SRC=http://www.wopr.com/w3tuserpics/Kevin_sig.gif alt="Keep the change, ya filthy animal...">
    <img src=/w3timages/blackline.gif width=33% height=2><img src=/w3timages/redline.gif width=33% height=2><img src=/w3timages/blackline.gif width=33% height=2>

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Oregon, USA
    Posts
    129
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Making Word Macro Pause

    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. <g>

Posting Permissions

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