Some mail merge fields not pulling into document


Joined
Jun 13, 2017
Messages
2
Reaction score
0
I use vba code to provide many mail merge documents from an Access database. I recently added a new table of data, pulled it into a query, related it via a common field. I can run the query and see the data i entered via an access form. I can run the vba process (oledb?) into a txt file. See the data accurate;ly in the text file. But it does not show up correctly in the document. Instead of showing 4 fields of data representing 6a, 6b. 6y and 6x, one of those fiels is repeated 4 times.

I am used to troubleshooting queries, but have never seen this happen before. Any glimmers of light out there?
 
Ad

Advertisements

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
513
Reaction score
47
That suggests all you done in the mailmerge main document is make 3 copies of the original field that is now repeating 4 times. That won't work; you need to specifiy the correct field name from the data source for each of the new fields.
 
Ad

Advertisements

Joined
Jun 13, 2017
Messages
2
Reaction score
0
Thanks for the reply. It was something like that. I had used bad field names beginning with a Numeral. So somehow the fields that began with numeral 6 were all pointing to the 6th column. When I was able to see the field names access was using they began with M_6a, M_6C etc. I had to code my mergefields with the M_ and then it all worked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top