Copying/pasting records and formatting question

[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]

[Fenton]

The easiest way is to create a calculation field with the fields you want, with paragraph returns, text, unstored, _cFields =

Field1 & "

[bruceR]

Try using a peform applescript step using the following:

set newData to ""

copy {name of every cell of current record, every cell of current record} to {cellNames, cellData}

repeat with k from 1 to count of cellData

if item k of cellData = "" then

-- skip

else

try

copy item k of cellNames & ": " & item k of cellData to temp

copy newData & return & temp to newData

end try

end if

end repeat

set the clipboard to newData

[alexandra_l]

thanks very much, the applescript method works very well.

this is only a small thing, but would there be a way to also have it put the first and second names (the first two fields) on the same line?