Access Data for Word Mail Merge - All Fields Showing in Word Document

[jglassner]

Hi all

I have a question and I am not sure if it an Access or Word issue.

I am setting a simple mail merge that has populates a few fields with data coming out of Access. The document is three pages and each page is the same except for the data I want to populate. On the Day 1 document, everything populates with no issue. Once I move onto the next pages I can see the mail merge field data but as soon as I preview it is gone, only white space. I have enclosed images to show what I am seeing.

What makes each page different is a different date and program number, otherwise, each page is the same. When I created the document I inserted a page break- next page thinking that would solve the issue.

With Merge Tag Image:
You can see the fields are populated.

No Data Populated, show the fields look empty when I preview the merge.

I can create three different documents but it would nice to have just one. Also, I am really curious about what is happening.

Being curious I used Excel as the go between for the data thinking that formatting in Excel would fix the issue. I create an Excel document and used Access as the source data. The Excel document was then used to populate the Word doc, that didn't help.

Thanks in advance,
J

 

[ranman256]

Access has all this built in so you wouldn't need word,excel.
Access reports can do the same thing. Why not use them?