I need to create some mailing labels and I can't figure out how to keep the data merged together on the individual labels. What I'm trying to do may be better explained by example.
The table storing the customer data has fields like name1, name2, name3, address1, and address2. Customer1 has: Name1: Bob Name2: Some Business Name3: Some Department Address1: 1234 Number Lane Address2: STE 1 Customer2 has: Name1: Joe Name2: Name3: Address1: 5678 Number Drive Address2: Address3: To get all of customer1's information on a label, I of course have to include all five fields. My dilemma is that I do not want customer2's information to print as: ------------------------------- Joe 5678 Number Drive ------------------------------- But instead I want it to print as: ------------------------------- Joe 5678 Number Drive ------------------------------- I hope this makes sense. J Matthew Burke Pioneer Bank - IT Department Computer Systems Technician 505-627-4415
