Select Fields of Table to Use When Printing Mailing Labels

[padlocked17]

I have a table that contains a lot of different information regarding to mailing.

There are columns for Name, Address, Address2, Address 3, City, State, Zip, Country, Base Name, etc.

Some units will only required parts of the above information. I'm using the Name as an identifier in the DB only and Address is the beginning of content that I want to use.

My issue stems out of the fact that the City, State, and Country are not always required but the Base Name, may be used in lieu of the City.

I was looking at making checkboxes next to each of the columns on the form on the field and then using those checkboxes somehow to create a report for Mailing Labels.

I'm just not sure how to set this up.

 

[johndoomed]

I'm not sure I understand exactly what the problem is, but I think you need to look into queries. Especially if you're thinking of importing the addresses to Word or other.

On the other hand, if you want to print the labels as a report, there s a lot of options with filter=.

I think we need more info in order to help you out. I'm a bit confused to be honest ;-)

 

[padlocked17]

Yeah it hards to describe what I'm looking for sometimes. Right now I have a form with all of the fields listed in a stacked format.

I want a check box next to each field that will be the selector for a report that will print off mailing labels. That way, anytime a person prints labels for that unit, it will only use the fields that are checked to generate a label.

 

[johndoomed]

You want to print just one label at a time? One label for one listing? Or one label for all listings in a table?

 

[padlocked17]

The number of labels wasn't the issue. It was that I basically had several columns in a table and I only wanted certain columns to print. I ended up just creating a label and then creating a fair number of Switch and IIf statements on the fields in the label and it ended up doing just what I wanted.

Granted I wanted a more GUI tpye interface so that I could just select the columns I wanted to print for each record by using a checkbox.

I'm still open if anyone has any ideas for that.

 

[padlocked17]

I might add that I am able to now select a starting point when printing on a sheet of labels and also specifiy how many individuals I actually want to print on a sheet. This allows for not all of labels to be printed on each time.