grandy12 wrote:I wis to use the data base function to send invitions to a party. It will contain the first and last names of each guest, his address and postal (Zip) code. How do I go about doing this?
Have you looked at the two examples of this in the Starting Points templates? Both "Caterer Address" and "Teacher Address" contain mailing label/shipping label layouts that perform the function you're looking for.
The "Address List" Assistant will also produce a Personal Address List DB that contains a mailing label layout. If using this one, I'd create a calculation type field to replace/combine the First Name and Last Name fields used in the first row, and another to replace/combine the three fields in the third line.
Formulas for these two:
'Fullname': 'First Name'&" "&'Last Name'
'City ST CODE': UPPER('City'&" "&'State'&" "&'Zip')
The Assistant-created DB does include a field similar to the last one above, but this version produces the
"CITY ST 12345" format mandated by Canada Post and by the US Postal Service (Provided that the State field contains the two letter symbols for the state name).
Regards,
Barry