Mail Merge to Word

nightflight

Registered User.
Local time
Today, 19:34
Joined
Mar 15, 2011
Messages
24
So i've got some nice buttons that when clicked take the results of qry_certissued and drop them into the appropriate word document,
GroupRecord.doc works fine, because it's just a table, and each new row has a <<next record>> at the start so Word knows to take the next record from Access and it's all OK.

But Certificate.doc is a single page, and with the old (but not so nice as my new database) method, it would use a table in another word document as the merge source, and for each record it found, it would create a new page with each individual person named on the certificate.
With my new database, it's only creating one page, with the first matching record on.

Similarly,
Pocket.doc has 8 small certificates on, each with a <<next record>> at the start of them, and this works fine, unless there are more than 8 people matching. Again, old system it would just create a new page and put the remaining people into the first couple of pocket certificates on the new page. New system just puts the first 8 matching records on and forgets about the remaining ones.

The OnClick() code on the buttons is
Code:
Private Sub btn_certificate_Click()
Application.FollowHyperlink "<filepath>\" & Me.cbo_certdatechoose.Column(1) & " Certificate.doc"
End Sub
(the difference in each case is the last bit before the .doc. the me.cbo_certdatechoose.column(1) picks up the prefix from the combo box and uses it as part of the filename)

On opening the word document, it looks for the merge source qry_certissued (which itself is specified by cbo_certdatechoose)
I don't really understand why GroupRecord.doc finds all (upto) 12 matching records, but certificate.doc and pocket.doc only bother with the first 1 or 8 respectively when the mail merge has been set up the same in each case.

Could someone shine some light on this?

Thanks
 

Users who are viewing this thread

Back
Top Bottom