Gmail Extract

[poizster]

I might be on the wrong forum for this question but here it goes. i have a gmail account that contains a folder or label called 'newsletter signup' inside the folder or label contains about 4,000 separate emails each when opened contains 1 unique e-mail address. I basically need a macro or some sort of gmail extraction program that can open each e-mail, copy the e-mail address, then paste into notepad or excel.

any suggestions?

Thanks!