Hi
can some one help me
Thanks
------------------------
Hi
can some one help me
Thanks
------------------------
as i can not open any of the posted emails, hard to test
Hi Westconn 1
Below is the mail example for your reference.
ThanksHTML Code:-----Original Message----- From: Central.Disbursements@supervalu.com [mailto:Central.Disbursements@supervalu.com] Sent: Friday, June 13, 2014 7:25 AM Subject: Dr/Cr Memos, Loc = 021011, 21212629 LOCATION 021011 SUPERVALU INC. VENDOR CHARGEBACK DOCUMENT 21212629 VENDOR 0325266 P.O. TOTAL AMT 25.00 CM FROZEN 6-8 MERCH ALLOW CREATED BY: Belinda Derr GENERAL MILLS MINNEAPOLIS SUPERVALU - EASTERN REGION ATTN DANETTE CONOBOY P.O. BOX 9340 PO BOX 714 MINNEAPOLIS MN 55440-9340 MINNEAPOLIS MN 55440-0714 CENTRAL.DISBURSEMENTS@SUPERVALU.COM DOCUMENT DATE 06/12/14 DUE DATE 06/12/14 DESCRIPTION QUANTITY PRICE AMOUNT UPC INT ITEM CD PACK/SIZE ------------------------------ ---------------- ------------ -------- ---------- VEGETABL/RICE BLND 1.00 25.0000 25.00 0000000-20000-27797 00719-4347 12/ 12OZ AMOUNT DEDUCTED SUPERVALU - EASTERN REGION 25.00
-----------------------
as vendor is before total amount, instr will return 0, which will cause error in MID
try
mynumber = val(mid(thebody, tot))
see if it gives the correct result for you