The actual "Merged" Document

Hi

I am trying to reference a merged document, hence I have my macro in
the Template, which merges to a seperate document. I then bring this
merged document (that can be called anything from "FormLetter1" to
"Letters1") into PRINT PREVIEW format.

From here, the user can choose what they want to do i.e. they can click
on the "x" or File Close/Exit, and I want not only the print preview to
close but the merged doc, e.g. Letters2 and then the template, BUT I
cannot seem to reference this merged document as its name isnt always
consistent.

I am able to get the doc in print preview format, and close the
template but as the macro is in the template I cannot close it, but am
awaiting the user to click on File Exit, and once they do that
everything will close, with NO CHANGES, i.e. the SAVE AS dialogue box
shouldnt appear!

I hope someone can help!

Thanx alot!

Preet x


---
Message posted from http://www.ExcelForum.com/

Dim maindoc as Document, mergeresult as Document

Set maindoc = ActiveDocument 'before the merge is executed
With maindoc.MailMerge 'etc

' code to execute the merge

End With

'after executing the merge, the result of the merge will be the active
document so use

Set mergeresult as ActiveDocument

' Now you have two document objects defined each of which can be acted upon
independently by reference to either maindoc or mergeresult as appropriate.
e.g.

maindoc.Close wdDoNotSaveChanges

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Preet " wrote in message
...
Hi

I am trying to reference a merged document, hence I have my macro in
the Template, which merges to a seperate document. I then bring this
merged document (that can be called anything from "FormLetter1" to
"Letters1") into PRINT PREVIEW format.

From here, the user can choose what they want to do i.e. they can click
on the "x" or File Close/Exit, and I want not only the print preview to
close but the merged doc, e.g. Letters2 and then the template, BUT I
cannot seem to reference this merged document as its name isnt always
consistent.

I am able to get the doc in print preview format, and close the
template but as the macro is in the template I cannot close it, but am
awaiting the user to click on File Exit, and once they do that
everything will close, with NO CHANGES, i.e. the SAVE AS dialogue box
shouldnt appear!

I hope someone can help!

Thanx alot!

Preet x


---
Message posted from http://www.ExcelForum.com/