Hi Gmayor,

Its my mistake , I got it now and I did not notice case sensitive . code is working fine but it has small issue again it is picking up the incorrect attachments lets say . for example
1) (customer ID : 350000 picking attachment that has with 3500000)
2) (customer ID : 86000 picking attachment that has with 386000)
3) (customer ID : 50000 picking attachment that has with 3500000 and 8450000)
4) (customer ID : 320000 picking attachment that has with 3320000 )

This is again led me to create doubt on my macro and had to do it manually . can you help me please .sorry for killing your time again .