May 15, 200421 yr hello everyone, i often copy all fields from my contact database records onto the clipboard to paste the data into emails etc., using the "copy record" script. because usually not all fields are filled out (home phone, work phone, home fax, work fax, etc.) the data appears with gaps once it's pasted into something else. is there a way to select all data from a record and have all fields appear on separate lines when pasted, preferably so that empty fields are ignored? so that someone with only name, email and home phone would appear like this: name email home phone instead of something like this: name email home phone thanks in advance for any hints! alexandra [email protected]
May 15, 200421 yr Using a calculated field may be easier, though it will not be dynamic if you want to add a new field to the list. Case( Length(name), name & "
Create an account or sign in to comment