+ Reply to Thread
Results 1 to 2 of 2

Import word attachment from Outlook into Excel

  1. #1
    Registered User
    Join Date
    01-27-2021
    Location
    Frankfurt
    MS-Off Ver
    2013
    Posts
    2

    Import word attachment from Outlook into Excel

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-27-2021
    Location
    Frankfurt
    MS-Off Ver
    2013
    Posts
    2

    Re: Import word attachment from Outlook into Excel

    Hey all,

    apologies for bumping this. Did anyone have a similar issue?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Send emails in Outlook with custom PDF attachment using Excel and word
    By malek_ali7sas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2020, 08:08 AM
  2. Extract Excel attachment from Outlook
    By Mark0098 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2019, 08:39 PM
  3. [SOLVED] EXCEL to OUTLOOK as attachment
    By Gtrtim112 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-02-2017, 01:00 AM
  4. Outlook Attachment To Excel
    By Frankinstyyn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2015, 05:57 AM
  5. [SOLVED] VBA Macro to print to Pdf format and place as attachment in Outlook (Excel & Outlook 2007)
    By Webman1012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-29-2013, 01:25 PM
  6. From Outlook, open a Word attachment, edit it and save as a PDF
    By Richard Buttrey in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2012, 03:54 AM
  7. From Outlook, open a Word attachment, edit it and save as a PDF
    By Richard Buttrey in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2012, 03:54 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1