E-mail Notification 1

[bradth]

What I would like to do is create an e-mail notification that would alert the salesperson that their sales order has shipped. I am currently using GP 7.5 and Outlook 2000. Basically, whenever a shipment for a sales order is made,
I would like to have an e-mail sent to the salesperson who entered it which contains the SO#, Customer, Items Shipped and Tracking numbers. Any idea how to go about doing this? I know there is a way to do it with SQL and creating a job, but I'm not sure how that works. Any examples would be much appreciated. Thanks

Brad

 

[bradth]

I finally got a chance to finish this and got it to work. What I did was wrote up a query for the message contents then created a stored procedure with the SQL e-mail in it. I then created a job that runs every night that will run the stored procedure, which then e-mail's certain people what SO's shipped for the day. Thanks again for all of the help, appreciate it much.

Brad

 

[jazgeek]

funny, isn't that what I originally suggested?

-----------
and they wonder why they call it Great Pains!

jaz