View Merged Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aleon - 27 Mar 2008 20:52 GMT

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?

Signature

aleon

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2008 03:41 GMT

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

Signature

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

>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
[quoted text clipped - 3 lines]
> button. Isn't there a way that when the document is opened, it appears
> merged?

Reply to this Message

aleon - 28 Mar 2008 15:39 GMT

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.

Signature

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?

Reply to this Message

Doug Robbins - Word MVP - 28 Mar 2008 23:36 GMT

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.

Signature

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

>I tried toggling the fields and saving like that, but I want the document
>to
[quoted text clipped - 7 lines]
>> button. Isn't there a way that when the document is opened, it appears
>> merged?

Reply to this Message

aleon - 08 Apr 2008 15:28 GMT

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.

Signature

aleon

> In your original post, you said "the merge fields don't display the data"
> when you select the View Merged Data button.
[quoted text clipped - 18 lines]
> >> button. Isn't there a way that when the document is opened, it appears
> >> merged?

Reply to this Message

Doug Robbins - Word MVP - 08 Apr 2008 19:56 GMT

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

Signature

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

> 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.
[quoted text clipped - 25 lines]
>> >> appears
>> >> merged?

Reply to this Message