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

jglassner

New Member
Joined
Apr 28, 2016
Messages
31
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
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
 

Attachments

  • With Merge Tags.jpg
    With Merge Tags.jpg
    135.5 KB · Views: 6
  • No Data Populated.jpg
    No Data Populated.jpg
    151.8 KB · Views: 6

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

ranman256

Well-known Member
Joined
Jun 17, 2014
Messages
1,913
Access has all this built in so you wouldn't need word,excel.
Access reports can do the same thing. Why not use them?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,936
Messages
5,545,105
Members
410,656
Latest member
Hydraulics
Top