VBA code to send information and compose a new email

[chin67326]

Hello there, in the attached file I have a worksheet with 2 textboxes and a command button. I want to be able to enter text in each text box and when I click the command button, I want it to open a new Gmail email (compose) in the Chrome browser and in the body of the email I want the information from the 2 textboxes to be pasted/shown there.

Most of the tutorials I am seeing refer to using Microsoft CDO for Windows 2000 Library and are for sending emails from Excel. I don't want the email to be sent and I just want it to be in 'compose mode' so I can add further information to the email if needed and then select my recipient and send the email.

When creating the code, assume the user is already logged into their Gmail account, therefore please don't suggest a code where the user's gmail address and password need to be entered in the vba code.

Can you please help to create the VBA code for the 'Send to Gmail' command button?

Also, Outlook is not an option. Therefore please code for Gmail.

Thanks!