Merging MS Access database into Word document.

[Mick]

Merging MS Access database into Word document. Using
Office XP (Word v 10.4219.4291, SP2, Access v
10.4302.4219). Word document 5 pages with embedded 73kb
image (bmp). 42 mail merge recipients. Requested duplex
print. When printing , document either doesn't print or
just prints first 2 pages of letter (back to back).
Merging 2 records prints OK

Any hints or tips will be greatly appreciated

Thanks
Mick

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Mick,

You may have to execute the merge to a new document and then run a macro
containing the following code when that document is active to cause the
letter for each recipient to be sent to the printer as a separate print job

Dim i as Integer
For i = 1 to ActiveDocument.Sections.Count
ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i
Next i

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP