Automatically send email to users queries in Excel with VBA
Our Excel training videos on YouTube cover formulas, functions and VBA or macros. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
http://www.exceltrainingvideos.com/au...
The present video shows how to send email to users queries in Excel with VBA automatically.
A user enters data in a form.
The data is captured to an Excel worksheet for record maintenance.
The email address is extracted from the Excel worksheet using the cells property and placed in the 'To' area of the email client.
Tracking numbers are assigned automatically.
The subject line and body of the email is also automated.
The email is sent quickly and the email client Outlook is closed automatically.