<div>
Great! This works well. <br />
<br />
One last thing, though, what to do if there is a printer error? <br />
<br />
Like if the printer is out of paper? or turned off?<br />
<br />
kathryn
</div>


Great! This works well.

One last thing, though, what to do if there is a printer error?

Like if the printer is out of paper? or turned off?

kathryn

<div>
kathryn<br />
<br />
please see<br />
<a href="http://www.vb123.com/toolshed/01_bugs/trappableaccess_errors.htm" rel="ugc">http://www.vb123.com/toolshed/01_bugs/trappableaccess_errors.htm</a><br />
<br />
482 Printer error 
</div>


kathryn

please see
http://www.vb123.com/toolshed/01_bugs/trappableaccess_errors.htm [http://www.vb123.com/toolshed/01_bugs/trappableaccess_errors.htm]

482 Printer error

<div>
Thanks for the points and the grade,<br />
<br />
I was thinking about this after I posted my comment,<br />
<br />
If the user have a lot mail merge files, I would prefer if you divide the above code in two parts,<br />
Part 1<br />
Deals with creating the mail merge files, with printing them.<br />
So that they can do this option even at off hours, on timer of say at 9 pm.<br />
<br />
Part 2<br />
Will do the printing.<br />
<br />
For the printing error handeling, you can use the normal error handling routine which is automatically produced once you create a command button with the wizard.<br />
<br />
I hope this helps,<br />
<br />
jaffer
</div>


Thanks for the points and the grade,

I was thinking about this after I posted my comment,

If the user have a lot mail merge files, I would prefer if you divide the above code in two parts,
Part 1
Deals with creating the mail merge files, with printing them.
So that they can do this option even at off hours, on timer of say at 9 pm.

Part 2
Will do the printing.

For the printing error handeling, you can use the normal error handling routine which is automatically produced once you create a command button with the wizard.

I hope this helps,

jaffer

<div>
<div class="content wysiwyg-content">
I have some complicated Word 2002 documents that need to be merged with data from an Access 2002 database. However, I'd like to control everything from Access, not from Word since the users do not know how to merge. How do I invoke and complete the merge programmatically from Access?<br />
<br />
Thanks in advance for any help.<br />
<br />
Kathryn
</div>
</div>


I have some complicated Word 2002 documents that need to be merged with data from an Access 2002 database. However, I'd like to control everything from Access, not from Word since the users do not know how to merge. How do I invoke and complete the merge programmatically from Access?

Thanks in advance for any help.

Kathryn

Invoking Word Merge from Access 2002

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.