Programmatically address the Save Dialog Box

[qbutler]

I have a publisher document that connects to a database and completes a mail
merge from an access DB table. The mailmerge completes into a new
publication. However I then have two instances of publisher open which is
fine. However when I close the merged document which contains the names from
the database I am prompted whether I want to save or not, that is ok. But
when I close the instance that has my template and the code I do not want to
be prompted with the save dialog box. Is there a way to programmatically
answer no to this question. I did try using:

Thisdocument.saved = true

to try and trick the application that it has already been saved and not to
prompt but it is a read only value and can not be modified.

Any insight on how I can accomplish this is greatly appreciated.

 

[Ed Bennett]

I have a publisher document that connects to a database and completes a mail
merge from an access DB table. The mailmerge completes into a new
publication. However I then have two instances of publisher open which is
fine. However when I close the merged document which contains the names from
the database I am prompted whether I want to save or not, that is ok. But
when I close the instance that has my template and the code I do not want to
be prompted with the save dialog box.

Is the template being opened from code? If so, one of the optional
arguments for the .Open method is whether to prompt to save changes,
silently save changes, or silently discard changes.

 

[qbutler]

Is the template being opened from code? If so, one of the optional

arguments for the .Open method is whether to prompt to save changes,
silently save changes, or silently discard changes.

Thanks Ed,

Initially I was not opening from code because I was still trying to make
sure I had my logic together from just the Publisher side of the house.
However I have made the transition over into Access, added my references,
created a button on a form. The button opens my publisher template and
successfully completes the mailmerge. It then closes my template with out
user interaction leaving open only the merged document. Which is what I was
looking for.

I believe you have resolved this issue for me.

Thanks bunches!

 

[Ed Bennett]

However I have made the transition over into Access, added my references,
created a button on a form. The button opens my publisher template and
successfully completes the mailmerge. It then closes my template with out
user interaction leaving open only the merged document. Which is what I was
looking for.

Fabulous, it's great to receive feedback for this, thanks for providing
it! Feel free to stop by if you have any more questions.