Hi guys,

I need a macro that automatically sends an outlook email every Friday of the week at 5pm.

For example,

Column A contains date like Late and On Time, if its Late, it will send an email.

It need to refer to column B to look for the person to email.

The column B contains codes or text, like 1,2, etc. Each code corresponds to different emailing list like for example 1 = joe@yahoo.com, 2 = jane@yahoo.com and so on.

Can anyone help me? This is too complicated for me, since it will be using the outlook.

The message in the email should be this “ You have a late delivery. Please refer to the delivery file for more details.”

Thanks! This is a good practice for some since this is something new I think.