hi again

still on my mailproblems im afraid... ive got a list of contacts that all need a follow-up mail sent to them. the thing is that i dont want to send to follow-up to close to the first mail, i need to wait a week before i send it. so the way i was thinking was like this: when ever i send the first mail i take tha date and email adress and stick it into a table (time_check). when i then go to send the follow-up it first checks the time code, and checks with the current date to se it a week has passed, before sending the mail. when th efollowup has been sent the old record is erased and a new one is put in its place.

the thing is that i cant the time_check to work. i dont know if this is the right way either... any ideas?

...

Add an additional field, called senddatetime or something and also another one called sendsearch.

Then, when sending, simply set senddatetime to Get(CurrentHostTimeStamp).

Then set sendsearch to be an unstored calc result number: If(GetAsDate(senddatetime) + 7 < Get(CurrentDate) ; 1 ; 0)

Then when looping through your records just add an if (sendsearch = 1) do whatever, else, do nothing.

...and suddenly everything seemed so simple...

thanks Genx