1)Outlook will receive an Email at 11:15 PM, with subject line DAILY RTIS TRANSACTIONS REPORT This email has an attachment, RTIS_TRANSACTIONS.CSV. All the rows from A2:J40 in the attachment should be copied to a template, RTIS_TRANSACTIONS_20180102, tab1 (RTIS_TRANSACTIONS_20180102).
2) Outlook will receive an Email at 12:30PM, with subject line Report CHESS Counts Per Hour for..
This email has an output table, which needs to be copied to template, CHESS tab.
3)3) Outlook will receive an Email at 12:50 PM, with subject line EFE CLAIMS PROCESSED REPORT
Copy all the contents from TIME to RTIS CT (of the email) TO template, CFE tab
Available Immediately | VBA expert | Mx Excel Guru | Working on a very similar extensive VBA project | Assured quality and timed delivery | Looking for more discussion on this
19 freelancers are bidding on average $178 for this job
Hello, Instead of naive VBA script, I can develop a professional .Net Outlook Addin, which will read incoming Emails and apply processing rules as mentioned. Regards, Usman
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards