One of my tasks is to repeatedly send email with almost the same body content to a receiver and I am wondering if I am automate this process.

Send email to <Receiver> with Body ( blah blah blah <ReceiverID> blah blah blah)

So the only this that changes in all these emails is the Receiver Email addresss and the ReceiverID in the body. Is there a script that I can write so I dont have to do this over and over again. Also not sure if this is the right forum for this kind of thing, but figured it could be done in VB Script. Thanks for all your help.

Check out this example done in MSAccess; you should be able to port the code to Excel without too much hassle!

DBForums Code Bank

Let us know how you get on

Check Ron deBruin's site Sendmail.