put the spreadsheet on your desktop and follow the instructions I gave you in the VB editor. it will open up automatically. you're on your own from there. this is not difficult.
Thank u once agian for the previous help, well i would like to know how to name the sheets, other than email1 email2 etc..Say i want to name them as A , B , C etcI am newbie and any help would be appreciated Thank u once agn for the support