Is it possible to create an Excel Macro to open outlook and search through text attachments and open specific named file?

Asked Sep 11 '19 at 14:21

Active Sep 11 '19 at 14:21

Viewed 28 times

I have an email (Outlook 2013) that comes in daily with several text file attachments. The email originates from the same sender "abc@abc.com" and the file attachments have the same name in every daily email "file.txt", "file1.txt", "file2.txt" etc. The email is delivered into a group inbox subfolder (group\subfolder). Is it possible to open the email from the subfolder from sender abc@abc.com and open a specific attachment "file2.txt" in Excel (Excel 2013). I'd like to run tests on the text file. More specifically if line 6 of the text file has ***** in it, then MsgBox "Nothing new"

I'm new to VBA cross-programs and need help. I've looked all over the web to find a usable example to no avail

If "file2.txt" has ***** on line 6 then an Excel MsgBox will pop up "Nothing New"

asked Sep 11 '19 at 14:21

smurfit

1

Could you show the VBA code you have tried? – MaartenDev Sep 11 '19 at 15:03
I don't know how to have Excel look into Outlook then open a file. I only know how to work inside Excel. – smurfit Sep 11 '19 at 19:03
https://stackoverflow.com/a/41476442/4539709 – 0m3r Sep 13 '19 at 22:57

Is it possible to create an Excel Macro to open outlook and search through text attachments and open specific named file?

0 Answers0