Assistance Required - Using VBA to send reminder emails.

[tf1989123]

Hi Experts!

I am new to VBA and currently I am exploring using VBA to help with sending reminder by just clicking one button. I have finished creating the coding for sending email via outlook but now I couldn't fix certain issue as follow:

- To send reminder email for certain date. Example if the due date is today, the program can auto detect/lookup the due date with today date in that column and send out the reminder email without sending email for other dates.
- To a command button which by clicking it, it will prompt the system to send email.


Below is the excel listing and VBA code

Column 1 is Name

Column 2 is Prof

Column 3 is Email

Column 4 is Due Date

-----------------------------------------------------------

Please Login or Register  to view this content.

Your Help is greatly appreciated!

[mrmmickle1]

You simply need to compare the date in column 4 to today's date.....

Please Login or Register  to view this content.

You may also consider using letters instead of numbers as it can be confusing later on:

Please Login or Register  to view this content.

[bakerman2]

Dates will be checked for Today+1

Please Login or Register  to view this content.

[FDibbins]

tf1989123 welcome to the forum

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I will add then for you - this time )

[tf1989123]

Thank you so much and it work! If I want to add a command button to trigger the send email. How the code should be added?

[tf1989123]

Thank you so much and I will read the forum rule again.

[tf1989123]

Thank you so much and your assistance. I will add this code to my list!