February 4, 200323 yr 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.?
February 4, 200323 yr 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.
February 5, 200323 yr Author could that have been any easier? duh! just the post editing was a bit of a pain. But Word
February 8, 200323 yr 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
Create an account or sign in to comment