Smart Mailer in Excel

Almost everyone who works with customers, suppliers, partners, subscribers or even colleagues faces the requirement of customized bulk emails. Such emails are usually created by a unified email template which contains tokens to insert personalized information like recipient Name, Title, Address, etc. To perform this activity, either we need to purchase a bulk mailing application or we need to use complex Mail merge activities.

Smart Mailer simplifies the whole task. It is a quick and easy way to prepare and send mass email messages straight from a customized MS Excel interface. 

 It is an Excel Add-In developed using Visual Basic for Application. To see Smart Mailer in action, you must have these 2 basic requirements:

1. Microsoft Office Outlook (configured with any email id)
2. Internet Connection

As it is an Excel Add-In, it can work with any Excel file. Eventually, it will save tons of hours.

View the demo of this application:

You can instantly download the application with a Password to fully access the VBA code. This means you can learn, customize, rename, rebrand, do what you want. It's yours. I am sure, this application will help you to grow and learn VBA functionalities in-depth as I have implemented awesome features in it.

ITS GREAT FEATURES:

• Compatible with Excel 2007, 2010, 2013, 2016, 2019, Office 365
• Small file size
• Sleek Looking product
• Very fast in processing
• Smart Signaling System to check Internet Connection
• Smart Signaling System to check Microsoft Outlook 
  
• Refresh option to recheck Internet & Outlook
• Instant Mail Report with errors (if any)
  
• Easy navigation using a dropdown menu
• Option to send different subject lines to different recipients
  
• Option to save email templates for further use
• Integrated with free text editor for Mail Body
• Integrated with mail tokens for dynamic contents
• Display last used and total used statistics
• Custom About Page for self or company branding
• Full editable and customizable

WHAT YOU WILL LEARN:

As you will have full access to the source code, you will be able to learn the concepts that I have implemented in it. You will be able to understand the following concepts:

• How to integrate Outlook with Excel?
• How to send mail using Outlook directly from Excel?
• How to check the internet connectivity status?
• How to check Outlook connectivity Status?
• How to create a multi page User Form in VBA?
• How to use Images in VBA forms?
• How to work on multiple User Form controls?
• How to save data to Windows Registry?
• How to delete data from the Windows registry?
• How to integrate Notepad in VBA for creating logs?
• How to create a beautiful drop-down menu in VBA?
• How to create beautiful progress bar in VBA?
• How to show / hide User Form Page based on conditions?
• How to work on Excel Tables in VBA?
• How to work on dynamic contents using Tokens?
• How to load Text documents into User Form?
• How to create Text document from User Form?
• How to create Folder form VBA?
• How to work on VBA Loops?
• How to work on VBA decisions?
• How to check for invalid email id formats?
• How to use Advanced Message Box?
  
• How to work with FaceId?
  
• How to use Advanced User Forms?
  
• How to Globally use Specific Text in VBA?
  
• How to use Windows API Functions?