Share via

Collating excel from multiple outlook mails.

Anonymous
2022-07-21T16:31:06+00:00

I have been given a task of collating multiple excel files with same format and heading but different data from each of the employees (count approx 40) into one excel file. Can anybody assist me in automating this entire/ part process by guiding me on some VBA codes or techniques, so that it can save my time by copy pasting each excel from outlook mails into 1 excel.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ashish Mathur 102K Reputation points Volunteer Moderator
    2022-07-21T23:40:43+00:00

    Was this answer helpful?

    0 comments
  2. Anonymous
    2022-07-21T23:23:28+00:00

    Hi there

    Please try the following.

    1. Create a folder and name it as you like.

    2} Download all the 40 attached files from Outlook into that folder

    1. On a new or an existing Excel file create a query following the instructions on the videos below.

    https://youtu.be/nPlrQUbEn4o

    https://youtu.be/pMQK1Zcc9jw

    Do let us know if you still need assistance.

    Regards

    Jeovany

    Was this answer helpful?

    0 comments