Printing a Phone List on an Avery Business Card

[Guest]

Is there a way to output names and phone numbers from a query to a list that
fits on an Avery business card by using the Reports label wizard? I
succeeded only in getting one name per card using the label wizard (in my
case, using Avery 8371). I want to try to get the whole team on as few cards
as possible.

 

[Vincent Johns]

Column settings are accessible via File --> Page Setup. Look at the
"Northwind Traders" database, the [Customer Labels] Report.

Or, you can use MS Word to set up your labels, and use Mail Merge to
grab names, phone numbers, &c., from your Access database. (But if you
are pulling data from more than one Table or Query for each label,
you'll need to define a Query that displays everything you want, as one
record, and specify that combined Query as your Mail Merge data source.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.