Print Labels Macro - VBA code?

[thomaszabel]

I have an Access database that includes a customer listing. My client would like me to include a button on a form that prints off all of their customers' names and addresses onto mailing labels. I know how to do it manually through the menu by clicking on the Customers table, clicking Labels under the Create ribbon, selecting the fields, selecting the label manufacturer, size, etc. etc., but the customer would prefer to have just one single button. (They aren't very technical, so they like lots of simple buttons)

I've looked everywhere for VBA code to put into a macro that does this. Unfortunately, unlike Excel, Access doesn't have a "Record Macro" option so I can attach it to the button.

Can anyone point me to the correct commands if they exist?

Table: Customers
Fields: FirstName LastName Address City State Zip (There are other fields, but they are not relevant to printing address labels)

Preferably Name on first line, Address on 2nd line, City State and Zip on 3rd line.

Thanks!

 

[thomaszabel]

Thanks!

In this case, all customers, so it can be simply based off the full table.

As far as Avery label size, I'm not sure which one they use, but if I could get the code for, say Avery 5160, I would probably be able to adjust it if they use another kind.

Maybe I'm hooked into doing this in VBA, and it would be better to design a form of some type that is aligned perfectly with whatever label dimensions they want. Not sure.

 

[thomaszabel]

Nice. Thanks so much! That's great.