BULK UPDATE error

I would like to update my table from external data. My SQL 2005 query is like: UPDATE table1 SET Photo = (SELECT *FROM OPENROWSET(BULK 'C:\Photo\photo1.jpg', SINGLE BLOB) AS Photo) WHERE EmployeeID = 0001
For some reasons some photos are missing from the directory and I would like to skip when executing the next UPDATE statement but the query stop after getting the error. Msg 4860, Cannot bulk load. The file "C:\Photo\photo1.jpg" does not exist. Any help to skip the error and move to next row?

Can you put an IF statement to check if file exists then only execute UPDATE?

You can use xp_getfiledetails.