Hello Paul,

Thanks for your reply. The macro is working abosolutely fine, instead on copying all resumes in one word document, i started saving each resume and kept the file name as samplereport 1, 2, 3 etc.

All the resumes data got imported to excel based on the format updated in demo file.

Many thanks for your macro.. it has saved me lot of time and work pressure.

Regards
Naveen Rao