<div>
You could also use Word to do a Mail Merge.
</div>


<div>
Oops, when i look back to my previous post I can see I edited it badly. The last line (&quot;You can do more or less...&quot;) should be ignored.<br />
<br />
Rob's correct that you can do a mail merge in Word - the only thing you can't do with that is insert report details if there is a list of items that apply to each individual - if this is not the case, Word mail-merge is often the simplest route.
</div>


<div>
Awesome! I never thought of doing a force new page. I had the query as the record source, just made this one little change to the detail section. Works perfectly!! I was making it too difficult. Thank you very much!!
</div>


<div>
<div class="content wysiwyg-content">
Experts. The collections department at my company is going to send out a year end settlement letter. I have a query of all of those individuals. In that query is their name and address. I need a one page report to print out for each individual in this query that includes their name and address for mailing. <br />
<br />
I haven't been able to find any vba code that I could put behind a 'print' button. Anyone have an example or advice?<br />
<br />
TIA!
</div>
</div>


Experts. The collections department at my company is going to send out a year end settlement letter. I have a query of all of those individuals. In that query is their name and address. I need a one page report to print out for each individual in this query that includes their name and address for mailing. 

I haven't been able to find any vba code that I could put behind a 'print' button. Anyone have an example or advice?

TIA!

do until to print report for each record in a query

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.