I have a question about extracting data from an Outlook message to an Excel spreadsheet. Usually, I'm able to extract the body of a message and the attachments associated with said message, but I do not know how to do that in order. This is what the message looks like:
What I need to do is put the date in the first cell of a row, followed by the text "Message[i]", and then open the XML file associated with that date and put the information of that XML file in the next cell of the same row.
Like I said, I believe I would be able to get text and the attachments, but I do not know how to associate the XML files with the dates, knowing that I don't know in advance the number of files per date.
Thank you for your time!
No comments:
Post a Comment