Hi All,
I am struggling with this small piece of code which should be pretty straightforward...(or so I thought).
Process is as follows:
1. I put a number of mails in a specific folder (most of them have an attachment, some multiple),
2. I would like to import the mail contents, in particular the content of the attachment, in an EXCEL file
3. Ideally I would refine it, so the input is a specific search key, that will ALWAYS be within the name of one of the attachments, and I only import the respective content.
I already managed to import the mail sender, mail body, etc + also the NAME of the attachment (at least if it is only one).
Now I would additionally like to import the attachment contents. Attachments are word files with tables in it. Ideally I would be able to set certain search keys to look for info in the docx and only import the info without downloading the docx. Alternatively, I would like to add a blank sheet and just copy the content (which are formatted as a table anyways) into the new sheets as a whole. Afterwards, i could then analyse it further.
Code so far attached.
PLEASE HELP. I tried everything and read 50+ articles, much appreciate any support here
Thanks,
Piet
Bookmarks