Thanks Cregan, I'm not very good at codes, Can you modify this VBA for a record via loop instead of query. Also if filepath to word doc is not found a find file option and save. Thanks in advance