View Single Post
  #10  
Old May 15th, 2008, 03:03 PM
hkinzler hkinzler is offline
Registered User
 
Join Date: May 2008
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
hkinzler is on a distinguished road
Smile One down, one to go (hopefully...)

Well, I was able to manage scripting a filter for the problem I stated above. The code:

show (every record whose cell "GEN.LASTACCESS" is less than "5/1/2006" and cell "Gen.EMAIL" is "*")


This now cuts the 19,000 records to a mere 6,400. All thats left is fixing the cell values, getting them into mail, and start sending those e-mails! I hope someone out there can offer any solution. Forums used to be something I paid no mind to, but now I might become an avid poster!

Note-Because of the security of the database I'm working with, I don't have some privledges to modify cell values/data. I hope that this won't be a problem (probably will be, what isn't¿) If it is, I'm sure I can get the rights, and everything then will work smoothly. Modifying those values, the "set":

set {firstNames, eMailAddresses} to {(every cell of document 1 whose name is firstNameCell), (every cell of document 1 whose name is eMailAddressCell)}

This is what the scripts hung up on now. Thanks and Good Luck for past and future help!
Reply With Quote