Works a treat Anil.  Thank You...

How do i do this Ash, what would be my procedure in producing this package....I know about XP_Sendmail sp, I have used this before, but how would i go about...

'Generally I avoid emailing things externally (Out of the network domain) from sql server'.  Why is this Ray, do u find it unreliable?  Also, the manifest will be scheduled to...

Thanks for your help guys...Much appreciated

I thought Trigger was wrong terminology!! Ah well

I currently have my DTS package in place to extract the data from the AS400.  I have my fields as well.

Planner Code:::Item No:::Quantity:::Minimum...