Excel to Word eMail Merge: Possible to suspend Send and force Preview?

[brucemc777]

After a tremendous amount of help from macropod and cytop we got the following code working great. I am wondering now if it is possible to stop just prior to sending out the emails so the user can preview the group in Word as if it were originally run from Word-

Please Login or Register  to view this content.

If it will take an entirely different approach then best forgotten, but if it isn't to involved I would like to incorporate the ability.

Thank-you!

[macropod]

If you want to preview the output, could send it to a document, not to email. Then, having previewed it and been satisfied that it is correct, execute the merge a second time and send it to email. the alternative is to disconnect your email app from the server, so all the emails go to your outbox so you can review them there...

[brucemc777]

Thank-you!