Read GMail via VBA

[kasmax]

Hi Guys
I have been trying to access gmail through vba in Access 2003. I can send an email from vba using CDO by using gmail account but i cant seem to find a way to read gmails email or download them in a table. i have searched quite a bit online but couldnt find any help.

so has anyone done something to achieve this? either using CDO or any other way or trick.
i will really appritiate the help.

Thanks

 

[kasmax]

Hi Again
Can anyone please help me out? i also need to mention here that i need to do it without using outlook.

ill appritiate help plz

 

[spikepl]

Checkout on Google what you can do with the free Thunderbird.

On reflection, I'd think that CDO also reads mails on the server. I haven't done that with CDO, so you probably need to google more.