thank's for replying, this si the line i have put in
strSQL = "INSERT INTO savedmail (mailID, recID, content) SELECT (mailID, recID, content) FROM internalmail WHERE mailID =" & mailID & ""
and i am getting the error
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query expression '(mailID, recID, content)'.
/year4/MMT4-155/move2.asp, line 23
line 23 is execute the sql,
any one know where its going wrong,