I need to send an email to each of the suppliers their present inventories using Outlook. If inventory is "0", set high priority flag.
Example:
Supplier Item Qty Email address
A 123 10 [email protected]
A 456 2 [email protected]
B B10 20 Reliable.xom
B B11 0 Reliable.xom
C C22 9 [email protected]
Thanks John