Updating DB Via Script

Well according to the log the estraction process from the email ocurrs first and then the Additional Action ocurrs but the first CSV file does not appear to close until after teh additional action script executes. The other funny thing here is that the file name does not show up in the log from the additional actions script.

NO I put the CSV filename inside the brackets. I will try the log addition to see if it is appending the fields that it is not currently appending. Good idea! Thanks I'll get back to You

Yea, I set up a second database file and tried to append to that as you suggested and the same fields are not updated. In addition I placed a Call AddToLog with the file name to see where it was executing in the sequence and it looks like it is correct. No matter what I do I cannot seem to get these particular fields to append. There doesn't seem to be anything different in the syntax of the Print statement and there is nothing special about these fields.

So, I am trying to update one of the fields with a calculated value in the print statement. It does not update this value. I am afraid I don't understand the syntax of this statement. It only wants to copy the fileds not allow an update as the For Next Loop iterates. If I want one of the fields in the append statement to update each record from within the For Next loop and the append statement, what syntax do I use. The value of the fielddata I am updating is iterating within the loop. I can see it in the the log data but I cannot seem to assign the value to the filedvalue in the print statement as the others are done. It only copies the fieldvalue and does not assign the new value every time the loop iterates. Any other ideas?

As it turns out, I found that if I assigned the loop counter value instead of the Fielddata value I was trying to insert in the append statement, the whole thing works. The fielddata value I was using in the print statement for one field would not update, but if I changed it to the loop counter value that was iterating (i) then all was well. It may have something to do with the fact that this particular  fielddata value was a calculated value from other data in the database, though it isn't clear to me why. Do you know if there is an after market reference book written about EMAIL2DB? I don't know how popular the program is but it is powerful and warrants a book of reference material. Thanks for all your help. Without your assitance I would have still been struggling but your help has allowed me to get a simple script running now.