Print Labels Macro - VBA

[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 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.

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?

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!

 

[EternalMyrtle]

Do they always use the same brand/size of labels? Why not just make the label report and provide a button to that report?