sending updates through email

[Guest]

I have a schedule of when vessels get to different docks to deliver goods.
The schedule is updated at least once a day. The schedule states the
client's name as well. Is there a way that when the schedule is updated that
it can automatically send the schedule information to each client regarding
their docks only? There are about 50 different clients and 11 different
vessels.

 

[Guest]

In a manner of speaking yes this is possible. If you are using Outlook as
your email client then you can use VBA to compose the emails. You will need
to create a reference to the Outlook object library and then compose emails
in code for each client affected.

However, using this method you will receive the obligatory warning that
Outlook generates when you try to compose and send an email. It will ask you
whether you wish to allow the composition and whether you wish to allow the
code to send the emails on your behalf. This isn't a great inconvenience but
it does take some of the automation out of the process.

 

[Ron de Bruin]

You can start here
http://www.rondebruin.nl/sendmail.htm

Look also at my CDO page