This is nothing terribly new under the sun. Give this web site a look to help
get you started...

http://www.rondebruin.nl/sendmail.htm

Once you have worked out how to send the emails then look at using

Application.Ontime

to do the e-mailing...
--
HTH...

Jim Thomlinson


"japorms" wrote:


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