By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 709 - CheckScheduleSendMail - udf - email

This code is part of the email chapter.

This routine uses a sheet to send emails from a sheet with a schedule on it

Steps

Showsheet with email schedule

assign cols to variables

for each row after header

if todays date in row
send email to yourself
y/n did you get email
- increment counter on sheet
- send the email to users listed in sheet
- save the workbook

Columns

emails to send

Sent

Who

File attachment

Actual date

Message