Compose mail in gmail VBA

[ExcelTheCell]

IE.Navigate "[URL]https://mail.google.com/mail/u/0/#inbox[/URL]"

I'm allways sign in. All i need is code that will click on Compose button and insert text in fileds TO,BODY and send to recipient, and possible to sign out from account
Any easy way...

 

[MyTech]

IE.Navigate "[URL]https://mail.google.com/mail/u/0/#inbox[/URL]"

I'm allways sign in. All i need is code that will click on Compose button and insert text in fileds TO,BODY and send to recipient, and possible to sign out from account
Any easy way...

As easy as:

IE.Navigate "https://mail.google.com/mail/u/0/#compose"

 

[ExcelTheCell]

Great you will come to the compose... Now, tell me how will you enter text in fields TO, Body and SEND TO and after that sing out... They use Iframes and it's really messy job to get actual code that will work without using CDO.mail.

 

[MyTech]

IE.Navigate "https://mail.google.com/mail/u/0/#compose&to=adreess@mail.com&subject=Test&bcc=address2@mail.com

 

[MyTech]

To sign out of gmail. (You probably learnt it yourself by now..)

IE.Navigate "https://mail.google.com/mail/u/0/?logout"

 

[ExcelTheCell]

IE.Navigate "https://mail.google.com/mail/u/0/#compose&to=adreess@mail.com&subject=Test&bcc=address2@mail.com

Well yeah iI have found out for the logout but code for compose will bring you back to inbox.. thanx for try but it doesnt work

Sub AfterLogin()
Dim IE As InternetExplorer
Set IE = New InternetExplorer
IE.Visible = True
IE.Navigate "https://mail.google.com/mail/u/0/#compose&to=adreess@mail.com"
End Sub

 

[MyTech]

I just tested it on my mobile AND on my pc. it really logs you out.
Compose does NOT bring me back.

 

[MyTech]

Yes, just started happening to me too, bringing me back to inbox instead of compose. I guess google is tricking on us.
Did you find any other workaround?
(last resort would be using sendkeys - gmail shortcuts.)