FourLegsGood
New Member
- Joined
- Nov 14, 2013
- Messages
- 1
G'day,
I see lots of vba macros to send a Gmail via EXCEL vba .. however..... I would like to figure a way to READ from GMail inbox into an EXCEL file ....
Reasoning:
We use Gmail to handle our customer inquires and we wish to know how many emails come in, from whom, ,Label, the subject etc...
So...
Would like to have an EXCEL VBA where one enters the Gmail account name / password and a date range - the macro proceeds, within a subsheet of the EXCEL, to import the email
The subsheet would have a header as follows;
Date, Sender Subject (LABEL - if possible)
.. and below - line by line list of emails
Not concerned about body or attachments...since we just wish to do metrics. Counting arrivals, dates, customer etc..
Thanx for your support.
Cheers,
Mike,
Ottawa, Canada
I see lots of vba macros to send a Gmail via EXCEL vba .. however..... I would like to figure a way to READ from GMail inbox into an EXCEL file ....
Reasoning:
We use Gmail to handle our customer inquires and we wish to know how many emails come in, from whom, ,Label, the subject etc...
So...
Would like to have an EXCEL VBA where one enters the Gmail account name / password and a date range - the macro proceeds, within a subsheet of the EXCEL, to import the email
The subsheet would have a header as follows;
Date, Sender Subject (LABEL - if possible)
.. and below - line by line list of emails
Not concerned about body or attachments...since we just wish to do metrics. Counting arrivals, dates, customer etc..
Thanx for your support.
Cheers,
Mike,
Ottawa, Canada
