How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask NewITZone Your Own Question
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I have received a large number of MSG files with attachments

Customer Question

I have received a large number of MSG files with attachments and I need to extract the attachments and the contains of the email into a format that I can review.
Need all of the email fields ie from, to , date, subject and email text and link it to the attachments..
How can I do this..
I have a list of the msg files in multiple folder the list is in excel.
Can I do it in ms access, excel vba or is there a software tool that I can use.
Submitted: 8 months ago.
Category: Microsoft Office
Expert:  Bhavik Joshi replied 8 months ago.

Hi, I'm Bhavik. Welcome to JustAnswer. I'm reviewing your question now, and will reply back ASAP.

Expert:  Bhavik Joshi replied 8 months ago.

So, What I understood is, You have lots of msg files with you, and you need a program or software which can extract details out of it and give you a document in form of an excel file.

Am I right ? or Did I miss anything ?

Customer: replied 8 months ago.

Yes and the attachments in a folder linked to the information for that email

Expert:  Bhavik Joshi replied 8 months ago.

Ok, This can done. I can write a macro code to do this.

This will take around 2 days to complete. And $40 extra. Are you okay with it ?

Customer: replied 8 months ago.

yes

Expert:  Bhavik Joshi replied 8 months ago.

Alright !! Can you send me sample attachment. So that I can take that as an example and use this for my testing ?

Expert:  Bhavik Joshi replied 8 months ago.

I did not understand why you attached these images. May be you were trying to upload something else and by mistake you attached this.

Customer: replied 8 months ago.

mistake please ignore had another open case with just answer

Expert:  Bhavik Joshi replied 8 months ago.

No Problem. Please attach some sample files.

Customer: replied 8 months ago.

Attachment: 2016-11-05_193125_email_attachments.zip

Trying to sending you a zip file if this is not getting to you tell me how to get it to you

Customer: replied 8 months ago.

Do you know when I can get the macro?

Also I need something else as well. Can you clear columns in the attachments that contain specific column headers.. ie "Name"

Expert:  Bhavik Joshi replied 8 months ago.

It is actually a bit time consuming task. More than what I thought initially.It will take some more time to complete.

Customer: replied 8 months ago.

Do you have any idea of when it will be done?

Expert:  Bhavik Joshi replied 8 months ago.

No, I am sorry, I tired with couple of codes but it is not giving results as we were looking for. I can show you few codes which does similar things, You can use them. But could not code as per your exact requirement.

Customer: replied 8 months ago.

Please show me what you can asap.

Expert:  Bhavik Joshi replied 8 months ago.

http://officetricks.com/outlook-email-download-to-excel/

Related Microsoft Office Questions