Copying/pasting records and formatting

[alexandra_l]

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]

[-Queue-]

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 & "