Access 2007 runtime database has list of customers. I want to print an address label for each customer on the list.
The address is in the customer table with CustomerID. It has customer name, street number and street name, city , state and zip or postal code. The address is already concatenated and ready to be used.
These are australian addresses.
The address needs 3 lines only -
First line is customer's name.
Second line is street number and street name.
Third line is city, state then zip or postal code.
I need to choose label size and quantity to print, then print the labels.
I need to be able to start printing on the next empty label if the sheet has some labels already used.
## Deliverables
All code and comments to be written by a native English speaker.
Each code routine must be tested and must work without errors.
I expect to see [login to view URL] used to show values for criteria and? sql statements. Make sure that the code works in the Access 2007 runtime.