My husband is a realtor and I am setting up my first DB for his 35 property listings. Two of my tasks are to track showings and advertising. I have created a Property Table and Layout with Listing ID (serial #) and relevant fields of info. - including 3 Fields for different ad lengths (bullets, short adcopy and long). Weekly I email publications with the properties to run showing the MLS #, price, photo and Adcopy. I use different ad lengths based on the publication, i.e. local newspaper gets short. How can I easily setup a list/report to email showing the property info and respective ad copy (size field).
Also, would like a report for the client showing their ad dates and publication. Thank you.