making an email list

[FritzOK]

I want to script copying the email adrs from all records of a Find and paste to either a new email or some other doc so that I could make a mailing list. Any ideas for this one.?

[jasonwood]

Just export your records to a text file, exporting only the email address field.

Then copy-paste that into the bcc field in an e-mail message.

[FritzOK]

could that have been any easier? duh!

just the post editing was a bit of a pain.

But Word

[Pupiweb]

Make a layout with only the email address field in it and run a script like

Go to layout (Email)

Copy All records

Go to layout (a normal layout)

Paste (gEmail) [gEmail is a global text field]

Set field (gEmail, Substitute (gEmail, "PP", ", ")

//Substitutes the carriage returns with commas

Send mail --> set the step to use field gEmail for the email recipients

OR

Set field (gEmail, "")

Go to record first

Loop

Set field (gEmail, gEmail & "PP" & Email)

Go to record Next, exit after last

End Loop

Set field (gEmail,Middle (gEmail,2,99999)

//Removes the first carriage return

Set field (gEmail, Substitute (gEmail, "PP", ", ")

//Substitutes the carriage returns with commas

Send mail --> set the step to use field gEmail for the email recipients

[FritzOK]

thanks. I