View Merged Data

[aleon]

I select the View Merged Data button in the Merge toolbar, but the merge
fields don't display the data. I want to be able to open the merge letter,
and have the data display, without having to select the Merge to New Document
button. Isn't there a way that when the document is opened, it appears
merged?

 

[Doug Robbins - Word MVP]

What do they display when you click on that button? It is is something like
{ MERGEFIELD "fieldname" }, then you need to toggle off the display of
fields codes using Alt+F9

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[aleon]

I tried toggling the fields and saving like that, but I want the document to
open with the fields already toggled, the document already merged.

 

[Doug Robbins - Word MVP]

In your original post, you said "the merge fields don't display the data"
when you select the View Merged Data button.

What do you see if you toggle the fields? I did not say to save the
document like that.

However, if you want the data to be merged immediately upon opening the
document, you will need to have code that executes the merge in a macro
named AutoOpen in the document, or AutoNew in template if the main document
is saved as a template.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[aleon]

Do you have code and macro that I could use? Also, where in the document
would I put this macro? It's a document and not a template. Thanks.

 

[Doug Robbins - Word MVP]

This code in a macro of the names mentioned in my earlier post will execute
the merge when the document is opened

With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With



--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP