I was wondering if the following is possible.
To create a VBA code so that when the commandbutton is clicked the selected sheet gets transformed to PDF format, and sends the email through Gmail. In gmail it should open the Gmail account automatically by writing the username and password and opens the compose, and attaches the PDF file it created.
Don’t have an account yet? Register yourself now and be a part of our community!