• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 309
  • Last Modified:

do until to print report for each record in a query

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!
0
acramer_dominium
Asked:
acramer_dominium
  • 2
1 Solution
 
SimonCommented:
I would suggest that you create a report based on your query. You can use the report Wizard to get you started. In the properties of the detail section, set the property "Force New Page" to "After Section".

You can do more or less the same without the grouping by just forcing new page AFTER each detail section.
0
 
Rob HensonFinance AnalystCommented:
You could also use Word to do a Mail Merge.
0
 
SimonCommented:
Oops, when i look back to my previous post I can see I edited it badly. The last line ("You can do more or less...") should be ignored.

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.
0
 
acramer_dominiumAuthor Commented:
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!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now