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 =
, 2 = 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.


--
japorms
------------------------------------------------------------------------
japorms's Profile: http://www.excelforum.com/member.php...fo&userid=6544
View this thread: http://www.excelforum.com/showthread...hreadid=572372