Don't know where to start...VBA gmail

[Lukums]

G'day guys...

New project came up and I'm clueless where to start on this one.

The idea is simple enough, emails will hit Sales@inbox.com.au which will go into a pool of sales inquiries.

When someone hits a button, they will get the oldest/or newest email extracted to a dashboard or excel as text.

If anyone has any ideas, or knows of any videos to reference I'd love to start reading/watching.

Many thanks,

Luke

 

[BrianJN1]

In my Thunderbird account I am able to apply filters in such a way that if I get, eg Sales@inbox.com.au I can divert it to a folder "Lukums, Honey@bees.com to "Sweets".
In that way I can presort a bulk of my emails. There I see the subject, who from and date.

I gather that what you want is to have Excel draw down from a gmail account, what? the Subject, Date, Fully body of text?

I've just called up my Gmail account and looked at the Page Source. Unfortunately it seems to be heavily loaded with what looks like a mix of XML syntax and Javascript.
I cannot readily anything to use as a key for a variable to use in VBA. Maybe others can.

 

[Lukums]

In my Thunderbird account I am able to apply filters in such a way that if I get, eg Sales@inbox.com.au I can divert it to a folder "Lukums, Honey@bees.com to "Sweets".
In that way I can presort a bulk of my emails. There I see the subject, who from and date.

I gather that what you want is to have Excel draw down from a gmail account, what? the Subject, Date, Fully body of text?

I've just called up my Gmail account and looked at the Page Source. Unfortunately it seems to be heavily loaded with what looks like a mix of XML syntax and Javascript.
I cannot readily anything to use as a key for a variable to use in VBA. Maybe others can.

Hello, Brian

Thanks for your response.

I'm going back to this one as I had no idea where to start a bit of investigation this is what I found (still clueless) though.

When an email hits Outlook IMAP profile - you can have a vBA sub running which will extract all the BODY of the email and place it on excel as a copy.paste function.

All I really want to happen is when an email hits the inbox to grab the body, place it on row the row I indiciate "row1" then incrementally every 50 as the paste function grabs the layout which could be up to 50 MAX.

I have no idea how to effectively manipulate outlook using vba but I know it's possible still don't know where to start.

 

[BrianJN1]

That is also beyond me. Sorry.