acramer_dominium
asked on
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rob Henson
You could also use Word to do a Mail Merge.
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.
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.
ASKER
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!!