Well, in that case, I think you probably need to take out the Execute as you
suggest, and ensure that the user is left with the merge main document open.
It is then up to them to select the correct records using either the
Mailmerge"recipients" dialog box (I think it is easier to do this if the
user has the mailmerge toolbar enabled), or the start and end record number
dialog that pops up when they actually initiate the merge.

Peter Jamieson
"darrensawyer via OfficeKB.com" u11419@uwe wrote in message
news:5ea9191650d32@uwe...
Thanks Peter

My objective it to open the merge document (which may be based on may
records)
and let the user decide whether they want to print all of them, some of
them
or one of them, and if necessary save to a new document.(s).

Ideally I want the merge document to act as a template and the content be
uneditable.

Peter Jamieson wrote:
At which point it launches asecond non-mailmerge doc based on the
data/original doc.

Yes, that's because it is performing the merge with the output going to a
new document. If you just want it to go to a printer, use

objWord.MailMerge.Destination = wdSendToPrinter

somewhere before your .Execute line.

so if I delete these lines of code can
be sure that the merge document will contain updated data (assuming the
csv
is uptodate of course.

No, because then you are not doing the merge. All that happens is that
your
mail merge main document is connected to the mail merge data source and if
the document is left open, the user will be able to "preview" the results.

( It isn't completely clear what overall result you are trying to
achieve )

Peter Jamieson
Hi

[quoted text clipped - 13 lines]

Thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200604/1