Contact Us

Assistance

For any assistance or queries send an e-mail to excelvbabot@gmail.com and tell us more about your requirements.


Feedback

Send an e-mail to excelvbabot@gmail.com for any suggestions, recommendations and feedback.


Follow Excel VBA Bot

Excel VBA Bot on Facebook Excel VBA Bot on Twitter Excel VBA Bot on Instagram 




Popular posts from this blog

Basics of VBA: Message Box

Image
   Bottom Line: Learn how to  use different VBA Message Box options. Note : Sample Excel with code included below. Please make use of it. Skill Level:  Beginner Sample File:  VBA-MessageBox.xlsm   Syntax: Prompt − Required parameter, a string, that is displayed as a message in the dialog box. All the others are optional parameters. Please check the below image for more info (Credits: Microsoft) Various MessageBox options:      1. with only 'Ok' button:                                                   Code: 2.  with 'Ok' and 'Cancel' buttons:                                                  Code:      3.  with 'Abort', 'Retry' a...
Read more

Sending Gmails using Excel VBA

Image
  Bottom Line: Learn how to send Gmails using Excel VBA , with attachments and body text, to predefined or dynamic list of recipients. Important aspects such as configuration changes, that need to be done in Gmail and Visual Basic Editor , for the code to work as expected, are also covered here. Note : Macro Template and other useful links related to Gmail configuration changes are included within/at the end of the post. Please make use of them.   Skill Level: Beginner Sample File:  VbaToSendGmail.xlsm Prerequisite: Basic VBA Hands-on knowledge Gmail configuration changes Enabling Microsoft CDO for Windows 2000 Library   1. Basic VBA Hands-on knowledge: Assuming you already have some basic knowledge on how to enable Developer option, accessing different objects in Visual Basic Editor and basics programming knowledge, providing some useful links relevant to the topic. Please go through the below links to quickly brush up the concepts: Getting starte...
Read more