Outlook Macro (Mails Auto forward to specific folder within outlook itself)

[hemant.83son]

Hi

can some one help me

Thanks
------------------------

[westconn1]

as i can not open any of the posted emails, hard to test

[hemant.83son]

Hi Westconn 1

Below is the mail example for your reference.

 
-----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

Thanks
-----------------------

[westconn1]

as vendor is before total amount, instr will return 0, which will cause error in MID

[hemant.83son]

Hi westconn1

Can you please correct it

Thanks
-----------------------

as vendor is before total amount, instr will return 0, which will cause error in MID

[westconn1]

try
mynumber = val(mid(thebody, tot))
see if it gives the correct result for you